Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group