用 brew 安裝 PostgreSQL client

只需用 homebrew 安裝 libpq formula

brew installl libpq

安裝完成訊息,把 libpq 的 bin 目錄加進 PATH 環境變數後 reload shell 即可使用

==> libpq
libpq is keg-only, which means it was not symlinked into /opt/homebrew,
because conflicts with postgres formula.

If you need to have libpq first in your PATH, run:
  echo 'export PATH="/opt/homebrew/opt/libpq/bin:$PATH"' >> ~/.zshrc

For compilers to find libpq you may need to set:
  export LDFLAGS="-L/opt/homebrew/opt/libpq/lib"
  export CPPFLAGS="-I/opt/homebrew/opt/libpq/include"

For pkg-config to find libpq you may need to set:
  export PKG_CONFIG_PATH="/opt/homebrew/opt/libpq/lib/pkgconfig"

看有哪些工具可以用

% ls -m /opt/homebrew/opt/libpq/bin
clusterdb, createdb, createuser, dropdb, dropuser, ecpg, initdb, pg_amcheck, pg_archivecleanup, pg_basebackup, pg_checksums, pg_config,
pg_controldata, pg_ctl, pg_dump, pg_dumpall, pg_isready, pg_receivewal, pg_recvlogical, pg_resetwal, pg_restore, pg_rewind, pg_test_fsync,
pg_test_timing, pg_upgrade, pg_verifybackup, pg_waldump, pgbench, psql, reindexdb, vacuumdb