Re: psql profiles?

On 07.12.2018 01:34, Matt Zagrabelny wrote:
> 
> 
> On Thu, Dec 6, 2018 at 4:24 PM Alvaro Herrera <alvherre@2ndquadrant.com 
> <mailto:alvherre@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