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
>> 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.
Life is not fair - get used to it.
In response to
pgsql-general by date
|Next:||From: Carsten Grewe||Date: 2002-01-29 08:43:51|
|Subject: problem with to_char|
|Previous:||From: Dmitry Alyabyev||Date: 2002-01-29 07:40:06|
|Subject: Re: Pg_dump options|