pg_dump schema - Mailing list pgsql-novice

From Nabil Sayegh
Subject pg_dump schema
Date
Msg-id 1060096045.6860.12.camel@billy
Whole thread Raw
Responses Re: pg_dump schema
Re: pg_dump schema
List pgsql-novice
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


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Permission error
Next
From: Nabil Sayegh
Date:
Subject: Re: pg_dump schema