X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E5EFC44EB5C for ; Mon, 27 Dec 2004 20:48:51 +0000 (GMT) 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 43960-07 for ; Mon, 27 Dec 2004 20:48:47 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id A4E4F44EB54 for ; Mon, 27 Dec 2004 20:48:45 +0000 (GMT) Received: (qmail 31992 invoked by uid 500); 27 Dec 2004 21:01:55 -0000 Date: Mon, 27 Dec 2004 15:01:55 -0600 From: Bruno Wolff III To: "Spiegelberg, Greg" Cc: pgsql-admin@postgresql.org Subject: Re: Pg_dump Message-ID: <20041227210155.GA29271@wolff.to> Mail-Followup-To: "Spiegelberg, Greg" , pgsql-admin@postgresql.org References: <387C22290D3FD71195D300508BF7DB5238AFCC@colmail01.cranel.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <387C22290D3FD71195D300508BF7DB5238AFCC@colmail01.cranel.local> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/247 X-Sequence-Number: 15833 On Mon, Dec 27, 2004 at 09:27:53 -0500, "Spiegelberg, Greg" wrote: > Benig able to exclude tables from dump's would be useful as well. There was some discussion about doing this kind of thing about 6 months ago (shortly before beta). I appearantly misremembered the end result of the discussion, but you should be able to find it in the archives. > > Greg > > -----Original Message----- > From: Tom Lane [mailto:tgl@sss.pgh.pa.us] > Sent: Sunday, December 26, 2004 6:34 PM > To: Bruno Wolff III > Cc: Gourish Singbal; pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Pg_dump > > > Bruno Wolff III writes: > > Gourish Singbal wrote: > >> allows me only to take dump of single table. Is there a way to take > >> dump of more than one specific tables. > > > I think this is a new feature for 8.0. > > No, it's not in 8.0 either; you still need a separate pg_dump run for each > table. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html