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 B70973CD7B2 for ; Sun, 26 Dec 2004 10:09:54 +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 74500-06 for ; Sun, 26 Dec 2004 10:09:48 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.196]) by svr1.postgresql.org (Postfix) with ESMTP id 079D63CD7B8 for ; Sun, 26 Dec 2004 10:09:49 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id i8so236902rne for ; Sun, 26 Dec 2004 02:09:49 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=NjL0SIcaMgnrh/0azBb4Snvq5CTBY2mA7uIxGzdIiPnCSU+ZS1gxn8Zo1ZhcOHYZqEZkIVDRdPifwr/ZQJKYodVTJwjgiXHtefUp1P+8ZHTfjSBGxH66T2ZTK/4KYvnReYT6yuT86f7U5jzIoDPsFwKUEWQf6d83t3ye/cFrD5s= Received: by 10.38.181.80 with SMTP id d80mr300132rnf; Sun, 26 Dec 2004 02:09:48 -0800 (PST) Received: by 10.38.97.69 with HTTP; Sun, 26 Dec 2004 02:09:48 -0800 (PST) Message-ID: <674d1f8a04122602097b3fa678@mail.gmail.com> Date: Sun, 26 Dec 2004 15:39:48 +0530 From: Gourish Singbal Reply-To: Gourish Singbal To: pgsql-admin@postgresql.org Subject: Pg_dump Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.104 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200412/240 X-Sequence-Number: 15826 1) I want to take a pg_dump of only few tables /usr/local/pgsql/bin/pg_dump -t [table_name] database_name > file.out allows me only to take dump of single table. Is there a way to take dump of more than one specific tables. 2) Does pg_dump allow me to take dump of a table so that only some records are included in the dump (Some thing like specifying a QUERY in the pg_dump) -- Best, Gourish Singbal