Re: dumping a pg_* table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dumping a pg_* table
Date: 2002-09-25 16:37:16
Message-ID: 11172.1032971836@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-09-25 16:45:18 Re: rotatelog / logrotate with PostgreSQL
Previous Message scott.marlowe 2002-09-25 16:32:46 Re: FAQ: upgrade recommendation