On Thu, Dec 6, 2018 at 4:24 PM Alvaro Herrera <alvherre@xxxxxxxxxxxxxxx> wrote:
On 2018-Dec-06, Matt Zagrabelny wrote:
> I'd rather do:
>
> psql foo
>
> and have it know that I connect to foo on host db-host-1.example.com.
>
> Is this possible with psql or do I hack together some wrapper script?
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.
Thanks again!
-m
