dumping a pg_* table

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: dumping a pg_* table
Date: 2002-09-25 14:12:54
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB04C73FB5@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Howdy:

I must be missing something simple: is it written
somewhere that I can not dump a table that starts
with pg_*? I can do a:

'pg_dump -t tmp_table -d database -f /tmp/tmp_table.dmp'

and get something, but I can't seem to get a dump
of the pg_* tables ... even when I use a '-U postgres'.

What am I doing wrong?

Thanks!

-X

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben Roberts 2002-09-25 14:13:15 Re: problem with maintenance script and missing pg_clog files with pg 7.2.1
Previous Message Dmitry Tkach 2002-09-25 14:03:22 Re: database abstraction -> functions