Re: Pg_dump options

Tuesday, January 29, 2002, 7:34:17 AM, Gurudutt wrote:

> Hello Troy,

> You could use one of these things to get it working..

> Create one txt file, input the username and password in different
> lines like

> Username
> Password

> save the file(user.txt)...

> Give this file as input to the pg_dump it should work

> pg_dump dummy_db < user.txt > /tmp/dummy_db.sql

> Hope it solves the problem, it worked for me...

yes, it works BUT you will have lines "Username:" and "Password:" in
your dump file. I think better to have these options in pg_dump (like
mysql_dump has) instead of doing this work around.

--
Dimitry