Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 9031E9FBBBC; Wed, 28 Feb 2007 18:57:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 53293-08; Wed, 28 Feb 2007 18:57:03 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc1-s8.bay0.hotmail.com (bay0-omc1-s8.bay0.hotmail.com [65.54.246.80]) by postgresql.org (Postfix) with ESMTP id A370F9FB5BA; Wed, 28 Feb 2007 18:57:23 -0400 (AST) Received: from hotmail.com ([65.55.136.91]) by bay0-omc1-s8.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Wed, 28 Feb 2007 14:57:22 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 28 Feb 2007 14:57:21 -0800 Message-ID: Received: from 65.55.136.123 by by131fd.bay131.hotmail.msn.com with HTTP; Wed, 28 Feb 2007 22:57:18 GMT X-Originating-IP: [67.116.31.14] X-Originating-Email: [skarthi98@hotmail.com] X-Sender: skarthi98@hotmail.com In-Reply-To: From: "Karthikeyan Sundaram" To: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org Subject: pg_dump inquiry Date: Wed, 28 Feb 2007 14:57:18 -0800 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 28 Feb 2007 22:57:21.0616 (UTC) FILETIME=[CDE35D00:01C75B8B] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.213 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/354 X-Sequence-Number: 24819 Hi, I have to dump only 10 tables out of 100 tables. In the pg_dump utility given by postgres there is an option called -t followed by table name. In that option, if I give more than 1 table, it's not accepting. How can I get the dump in one stroke for all the 10 tables? Please advise. Regards skarthi _________________________________________________________________ Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month. Intro*Terms https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search=mortgage_text_links_88_h27f6&disc=y&vers=743&s=4056&p=5117