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