Re: Reading psql password from stdin

pg_dump does wait for passwords - version 7.1.x.

But the password prompts end up in the dumpfile.

That is to say, the Username: and/or Password: prompts end up in the
dumpfile and are not displayed on the screen.

Cheerio,
Link.

At 06:19 PM 14-10-2001 -0600, Keary Suska wrote:
>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"