Re: Reading psql password from stdin

Good, good, very good! being one of the people who steadfastly avoids PGUSER
and PGPASSWORD for security reasons, it would be nice t be able to do
$ psql db user < file
As the docs say you can. Would this change also allow the use of:
$ pg_dump > dumpfile
Which doesn't work when prompting for password, but that can be a stdout
issue.

I would enumerate these issues as the top annoyances with the postgres
client apps. Although I would place them very low compared to being able to
alter/remove columns.

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"

> From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
> Date: Sun, 14 Oct 2001 19:07:25 -0400 (EDT)
> To: PostgreSQL-general <pgsql-general(at)postgresql(dot)org>
> Subject: [GENERAL] Reading psql password from stdin
>
> We have recently realized that psql and pg_dump read passwords from
> stdin, rather than from the more traditional /dev/tty. I would like to
> change the default to /dev/tty and read from stdin only when /dev/tty
> can't be opened.
>
> Is this good or bad? I need votes.
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>