On 07.12.2018 01:34, Matt Zagrabelny wrote:
On Thu, Dec 6, 2018 at 4:24 PM Alvaro Herrera <alvhe...@2ndquadrant.com <mailto:alvhe...@2ndquadrant.com>> wrote:Sure, just define a pg_service.conf file. https://www.postgresql.org/docs/11/libpq-pgservice.html Thanks Alvaro! Is there any shorter version than: psql "service=foo" ?If not, I can make a shell alias that puts the "service=$@" into the command.
Also you can set environment variable PGSERVICE=foo in your .bashrc. Or you can just set variable PGHOST=db-host-1.example.com. In last case you don't need pg_service.conf file.
-- Arthur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company
