X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 37D04DAE30 for ; Tue, 25 Oct 2005 19:42:11 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50192-08 for ; Tue, 25 Oct 2005 22:42:06 +0000 (GMT) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9E829DA8FA for ; Tue, 25 Oct 2005 19:42:07 -0300 (ADT) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1EUXTS-0004Ng-Gk for pgsql-admin@postgresql.org; Wed, 26 Oct 2005 00:40:54 +0200 Received: from srv.protecting.net ([212.126.218.242]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 26 Oct 2005 00:40:54 +0200 Received: from hf0923x by srv.protecting.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 26 Oct 2005 00:40:54 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: Harald Fuchs Subject: Re: excluding a table from pg_dump Date: 25 Oct 2005 19:39:51 +0200 Organization: Linux Private Site Lines: 12 Message-ID: <874q75sdg8.fsf@srv.protecting.net> References: <60zmoxblq0.fsf@dba2.int.libertyrms.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: srv.protecting.net User-Agent: Gnus/5.0808 (Gnus v5.8.8) Emacs/20.7 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 required=5 tests=[AWL=0.007] X-Spam-Level: X-Archive-Number: 200510/270 X-Sequence-Number: 19342 In article <60zmoxblq0.fsf@dba2.int.libertyrms.com>, Chris Browne 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.