Re: dumping a pg_* table - Mailing list pgsql-general

From Tom Lane
Subject Re: dumping a pg_* table
Date
Msg-id 11172.1032971836@sss.pgh.pa.us
Whole thread Raw
In response to dumping a pg_* table  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
List pgsql-general
"Johnson, Shaunn" <SJohnson6@bcbsm.com> writes:
> I must be missing something simple:  is it written
> somewhere that I can not dump a table that starts
> with pg_*?

Yeah, right in the pg_dump sources, about line 2100 of pg_dump.c
in release 7.2 ;-)

Why would you want to do a pg_dump of a system catalog, anyway?
You couldn't restore it.  Perhaps what you really want is pg_dump's
-s (schema only) option.

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: FAQ: upgrade recommendation
Next
From: "scott.marlowe"
Date:
Subject: Re: FAQ: upgrade recommendation