Re: excluding a table from pg_dump

From: Harald Fuchs <hf0923x(at)protecting(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: excluding a table from pg_dump
Date: 2005-10-25 17:39:51
Message-ID: 874q75sdg8.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

In article <60zmoxblq0(dot)fsf(at)dba2(dot)int(dot)libertyrms(dot)com>,
Chris Browne <cbbrowne(at)acm(dot)org> writes:

> A usual reason why I would want to dump everything except for a few
> tables is that those few tables are particularly enormous and
> particularly useless (at least, for the purposes of my dump).

> In that case, the LAST thing I want to do is to make extra copies of
> the *useless* tables.

As long as we don't have "pg_dump -X" (or something like that) you
could put the tables you don't want to dump into another schema.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-10-25 18:09:25 Re: files to ignore during pitr base backup
Previous Message Chris Browne 2005-10-25 16:33:11 Re: excluding a table from pg_dump