From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: exclude a table from pg_dump |
Date: | 2002-09-27 14:10:51 |
Message-ID: | 20020927101051.B18633@mail.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Sun, Sep 22, 2002 at 02:27:52PM +0300, Kostis Mentzelos wrote:
> Hi all,
> is it possible to exclude a table from being pg_dumped?
Not really. If you knew there were no connections (and therefore
no-one changing data) you could do it in a shell script, passing the
-t option to pg_dump for each table except the one you want. But
that won't provide you with a truly guaranteed-consistent dump like a
normal pg_dump does.
I thought someone said something about adding a multiple-table
feature to the 7.3 pg_dump, but I just tried it on the beta, and it
didn't work differently than in 7.2.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
From | Date | Subject | |
---|---|---|---|
Next Message | Nick Fankhauser | 2002-09-27 14:16:01 | Re: hardware question |
Previous Message | Andreas Schmitz | 2002-09-27 08:42:40 | Re: hardware question |