Re: request for feature: psql 'DSN' option - Mailing list pgsql-hackers

From hubert depesz lubaczewski
Subject Re: request for feature: psql 'DSN' option
Date
Msg-id 9e4684ce0607080435y38da7141l9cea68e0d05ff6e4@mail.gmail.com
Whole thread Raw
In response to Re: request for feature: psql 'DSN' option  ("Andrew Dunstan" <andrew@dunslane.net>)
Responses Re: request for feature: psql 'DSN' option  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On 7/7/06, Andrew Dunstan <andrew@dunslane.net> wrote:
Why is this better than using the service file?


service file is not well described in manual. quick grep showed that we have PGSERVICE variable, and pg_service.conf.sample, which doesn't even include all possible parameter names.
and - comments in this file suggest it is to be used globally only: "Copy this to your sysconf directory (typically /usr/local/pgsql/etc) and...", and not "per user".
i would really love to see pg_service.conf extended in such a way that i could:
1. store it in $HOME/.pg_service.conf
2. use name of service on psql invocation (not as env variable). preferably using psql service_name. this will conflict with current behaviour (treating argument as dbname), but with some basic logic, i belive it can be done.

just my $0.02.

depesz

pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: DISTINCT/Optimizer question
Next
From: Jim Nasby
Date:
Subject: Re: system info functions