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.


Mon, 17 Sep 2001 09:46:29 +1000 (EST)
speedboy <speedboy@nomicrosoft.org>
pg_dump and -U flag.
nevermind, PGUSER is the variable


Mon, 17 Sep 2001 09:55:27 +1000 (EST)
speedboy <speedboy@nomicrosoft.org>
Re: pg_dump and -U flag.