macOS Postgres.app 配置命令行工具

执行命令

执行完成后需重新打开终端。

sudo mkdir -p /etc/paths.d &&
echo /Applications/Postgres.app/Contents/Versions/latest/bin | sudo tee /etc/paths.d/postgresapp

提供的命令

PostgreSQL

clusterdb createdb createlang createuser dropdb droplang dropuser ecpg initdb oid2name pg_archivecleanup pg_basebackup pg_config pg_controldata pg_ctl pg_dump pg_dumpall pg_receivexlog pg_resetxlog pg_restore pg_standby pg_test_fsync pg_test_timing pg_upgrade pgbench postgres postmaster psql reindexdb vacuumdb vacuumlo

PostGIS

pgsql2shp raster2pgsql shp2pgsql

官方文档

https://postgresapp.com/documentation/cli-tools.html