Re: Pg_dump options

Hello Dmitry,

Yes!! I fully agree with what you say, the option should've been there
in pg_dump just the way it is in mysql_dump. But Username: & Password:
won't be there in the dump file if u write the pg_dump command in a
shell script and execute it inside the shell.

Tuesday, January 29, 2002, 1:10:06 PM, you wrote:

DA> 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...

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

--
Best regards,
Gurudutt mailto:guru(at)indvalley(dot)com

Life is not fair - get used to it.
Bill Gates