pg_dump and -U flag. - Mailing list pgsql-hackers

From speedboy
Subject pg_dump and -U flag.
Date
Msg-id Pine.LNX.4.21.0109170942270.695-100000@b.evark.com
Whole thread Raw
Responses Re: pg_dump and -U flag.  (speedboy <speedboy@nomicrosoft.org>)
List pgsql-hackers
I am trying to use pg_dump as user root but using another username for the
database.

I set USER="postgres" and exported it. It still tries to login using the
root username. PGPASSWORD can be set and exported, is there a way I can do
this for the username?

Also, could it be possible for someone to program support in pg_dump to
have a -U flag/argument to set the username that pg_dump will use?

p.s. I'd like not to use -S and expect.

Thankyou.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: factorial doc bug?
Next
From: speedboy
Date:
Subject: Re: pg_dump and -U flag.