Thread: pg_dump schema

It has several schema, each owned by a different user.
The db itself belongs to another different user.

How can I as userX dump my schema ?

> pg_dump -U userX db -t nav2
pg_dump: Attempt to lock table "nav2" failed.  ERROR:  userY: permission
denied

TIA
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de

Am Die, 2003-08-05 um 17.07 schrieb Nabil Sayegh:
> It has several schema, each owned by a different user.
> The db itself belongs to another different user.
>
> How can I as userX dump my schema ?
>
> > pg_dump -U userX db -t nav2
> pg_dump: Attempt to lock table "nav2" failed.  ERROR:  userY: permission

Sorry,

userY is supposed to be schemaY (which is the same in my case).
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de

Nabil Sayegh <postgresql@e-trolley.de> writes:
> How can I as userX dump my schema ?

In CVS tip, pg_dump has a "--schema=SCHEMA" switch, but I think it did
not exist in 7.3 :-(

            regards, tom lane