Re: excluding a table from pg_dump - Mailing list pgsql-admin

From Harald Fuchs
Subject Re: excluding a table from pg_dump
Date
Msg-id 874q75sdg8.fsf@srv.protecting.net
Whole thread Raw
In response to Re: excluding a table from pg_dump  (Hannes Dorbath <light@theendofthetunnel.de>)
Responses Re: excluding a table from pg_dump
List pgsql-admin
In article <60zmoxblq0.fsf@dba2.int.libertyrms.com>,
Chris Browne <cbbrowne@acm.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.

pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Why different execution times for different instances for the same query?
Next
From: Sidar López Cruz
Date:
Subject: zero performance on query