pg_dump permissions - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject pg_dump permissions
Date
Msg-id 4356048C.1000404@familyhealth.com.au
Whole thread Raw
List pgsql-hackers
Suppose I have a database with a table in it.  I try to dump that 
database.  The user I dump as is not the owner of that table nor does it 
have the SELECT permission on that table.

Why can't I do a schema-only dump of that table?  I find that I need 
SELECT permission on the table, even though my user can happily query 
the catalogs.

PostgreSQL version: 7.4

Chris



pgsql-hackers by date:

Previous
From: Richard Huxton
Date:
Subject: Re: SIGSEGV in Postgres 8.0.3 (libpq4)
Next
From: daveg
Date:
Subject: Segv in pg_autovacuum in 8.0.x