Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 4687F9FB82F for ; Tue, 19 Jun 2007 02:42:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 28275-01 for ; Tue, 19 Jun 2007 02:42:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id AC1D59FB85E for ; Tue, 19 Jun 2007 02:42:09 -0300 (ADT) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1I0WTg-0000Ro-RC for pgsql-admin@postgresql.org; Mon, 18 Jun 2007 22:42:08 -0700 Message-ID: <11188794.post@talk.nabble.com> Date: Mon, 18 Jun 2007 22:42:08 -0700 (PDT) From: cha To: pgsql-admin@postgresql.org Subject: pg_dump: Exclude multiple tables in version 7.4 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: chandresh.rana@metrixline.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/175 X-Sequence-Number: 25843 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#a11188794 Sent from the PostgreSQL - admin mailing list archive at Nabble.com.