pg_dump schema

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: pg_dump schema
Date: 2003-08-05 15:07:25
Message-ID: 1060096045.6860.12.camel@billy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2003-08-05 15:12:37 Re: pg_dump schema
Previous Message Tom Müller-Ackermann 2003-08-05 14:54:20 FUNCTION REPLACE() "does not exist" ?