It looks like setting the PGUSER and PGPASSWORD
environment variables does the trick. I don't know
where that is in the documentation (PGUSER is in the
psql man page, but I wasn't able to find PGPASSWORD).
So something like:
PGUSER='postgres'
PGPASSWORD='secret'
export PGUSER PGPASSWORD
pg_dump -h mydatahost mydatabase -t mytable
Seems work just like you would expect.
I hope this is helpful,
Jason
--- Aldo Vadillo Batista <avadillo@ulpgc.es> wrote:
> Hi everybody,
>
>
> If you execute "pg_dump -u database", pg_dump
> permits you to specify the user who is making the
> dump. But then, pg_dump waits for you to insert the
> user name and the password.
>
> I want to make automatic scripts to create the
> copies and I have the problem of interactive I/O.
> I am using postgresql 7.1, how can I make the
> copies?
>
> Thanks in advance.
>
> Saludos,
>
> Aldo Vadillo Batista avadillo@ulpgc.es
> Subdirecci�n de Comunicaciones - ULPGC
> Las Palmas de G.C. - Islas Canarias
>
>
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/