Re: psql: default base and password reading - Mailing list pgsql-patches

From Peter Eisentraut
Subject Re: psql: default base and password reading
Date
Msg-id Pine.LNX.4.30.0110122204290.648-100000@peter.localdomain
Whole thread Raw
In response to Re: psql: default base and password reading  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: psql: default base and password reading
List pgsql-patches
Tom Lane writes:

> > 2. Password is reading from terminal (/dev/tty) rather than from
> > stdin.
>
> Hmm, that might be a good idea.  Comments anyone?

I guarantee you that within 24 hours after such a patch were checked in
someone's going to complain that he has no /dev/tty.

Meanwhile, there are a couple of possible workarounds:

* PGPASSWORD environment variable.

* FIFOs

* (echo "Password"; pipe_input) | psql

A generalized option to read the password from any file might make sense,
though.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: psql: default base and password reading
Next
From: Peter Eisentraut
Date:
Subject: Re: Showing index details with \d on psql