X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 41C779FA279 for ; Fri, 26 May 2006 10:52:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 45646-06 for ; Fri, 26 May 2006 10:52:14 -0300 (ADT) X-Greylist: delayed 00:06:36.549916 by SQLgrey- Received: from qtm.net (mummra.qtm.net [216.163.32.14]) by postgresql.org (Postfix) with SMTP id 257339F9B01 for ; Fri, 26 May 2006 10:52:13 -0300 (ADT) Received: (qmail 75841 invoked from network); 26 May 2006 13:44:09 -0000 Received: from unknown (HELO ?192.168.1.4?) (mur@216.163.42.13) by mummra.qtm.net with SMTP; 26 May 2006 13:44:09 -0000 Message-ID: <44770674.2010800@endpoint.com> Date: Fri, 26 May 2006 09:45:24 -0400 From: Jeff Boes Organization: End Point, Inc. User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: pgsql-admin@postgresql.org CC: "renneyt@yahoo.com" Subject: Re: PG_DUMP References: <4476892A.7090201@yahoo.com> In-Reply-To: <4476892A.7090201@yahoo.com> X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/377 X-Sequence-Number: 21909 renneyt@yahoo.com wrote: > Is there a way to do a selective pg_dump of a table using a select > where clause? As in ... dump all records where now-col_date < 2 or > col_date='01-may-2006' etc.. ? You can transfer the subset of data to another table, e.g., create table my_dump as select * from table_foo where ... and then dump that table. Note that you can't do this to a view (pg_dump will dump the view definition, but not the data). -- Jeffery Boes <>< jeff@endpoint.com