Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6D99E9FC03C for ; Thu, 21 Jun 2007 12:24:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 21716-10 for ; Thu, 21 Jun 2007 12:24:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id C95B99FC032 for ; Thu, 21 Jun 2007 12:24:26 -0300 (ADT) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1I1OWI-0005Y0-8w for pgsql-admin@postgresql.org; Thu, 21 Jun 2007 08:24:26 -0700 Message-ID: <11235484.post@talk.nabble.com> Date: Thu, 21 Jun 2007 08:24:26 -0700 (PDT) From: cha To: pgsql-admin@postgresql.org Subject: Re: pg_dump: Exclude multiple tables in version 7.4 In-Reply-To: <11188794.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: chandresh.rana@metrixline.com References: <11188794.post@talk.nabble.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200706/224 X-Sequence-Number: 25892 Hi, Am able to figure out the solution for the issue. I accomplish the task by writing the ant script and batch file. In the batch file am passing the table name as arguments. Only thing I had to do manually is to list out the name of the tables in batch file. Cheers, Cha cha wrote: > > Hi All, > > I want to dump the database by using pg_dump command but the problem is > the version at the server is 7.4 which doesn't support the provision for > excluding tables as in version 8.2. > > There are 500+ tables in the database,from which 15-20 are of huge sizes.I > want to exclude them.Is there any way to do it? > > I knw that I have to use include instead of excluding the tables.Do I have > to include each and every tables manually or is there way to do that? > > Do i have to write the script for this? if yes, how should I proceed? > > Please help me out with this issue. > > Thanks in Advance. > > > Cheers, > Cha > -- View this message in context: http://www.nabble.com/pg_dump%3A-Exclude-multiple-tables-in-version-7.4-tf3944402.html#a11235484 Sent from the PostgreSQL - admin mailing list archive at Nabble.com.