postgresql通过环境变量设置Connection options缺省值

通过环境变量 PGDATABASE、PGHOST、 PGPORT以及PGUSER 设置Connection options缺省值。

export PGPORT=5433设置缺省port

export PGUSER=postgres设置缺省username

psql --help

Connection options: --host=HOSTNAME      database server host or socket directory (default: "local socket") --port=PORT          database server port (default: "5433") --username=USERNAME  database user name (default: "postgres") --no-password        never prompt for password --password           force password prompt (should happen automatically)

-bash-4.2$ psql psql (9.6.19) Type "help" for help.

postgres=# show port;  port ------  5433 (1 row)

postgres=# select current_user;  current_user --------------  postgres (1 row)

postgres=#