Re: supplying password to psql on command line?

On Tue, Oct 29, 2002 at 08:52:12AM +0100, Christoph Dalitz wrote:
>
> > Date: Mon, 28 Oct 2002 10:56:32 -0800
> > From: Medi Montaseri <medi.montaseri@intransa.com>
> >
> > I think Font ends are moving away from this approach as others can see
> > your supplied
> > passwd by a simple ps(1) command.

> Unfortunately this does *not* work with psql because for some strange reason
> psql does not read the password from stdin.

You can always use PGPASSWORD.  And for those of you that find that
envvar insecure or cumbersome, there's a new ~/.pgpass where you can
store passwords in 7.3.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Y dijo Dios: "Que sea Satanás, para que la gente no me culpe de todo a mí."
"Y que hayan abogados, para que la gente no culpe de todo a Satanás"