Hm, I usually use
pg_dump -f smthng.out dbname -u
after that program asks for username and password,
there were some possibilities within postgres too, but you can find them
yourself. And why not to dump all data as superuser, that way u have no
problems with privileges at all.
Antti
On Tue, 3 Oct 2000, Marcin Mazurek wrote:
> Hi,
> is something like this possible?
> I have to grant select priviliges to dump database, and I was wondering if
> there is easer way to do it then name one, by one every table.
>
> maz
>
> Marcin Mazurek
>
> --
> Kierownik Dzia³u Systemowego
> MULTINET SA o/Poznan
> http://www.multinet.pl/
>