Re: psql and passwords

Curt Sampson wrote:
> On 15 Apr 2002, Doug McNaught wrote:
>
> > "Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> >
> > > Anyway, the solution is to set PGPASSWORD in the evironment. Once I
> > > remembered about that it all became so much easier.
> >
> > Note that this is potentially insecure as some systems expose your
> > environment to other users.
>
> Indeed. What about adding an option whose argument is the name of
> a file containing the password?

Already on TODO and I hope it is done for 7.3:

* Add PGPASSWORDFILE environment variable or ~/.pgpass to store
  user/host/password combinations

We even have:

* Remove PGPASSWORD because it is insecure on some OS's

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026