X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id BE23ED1C9E1 for ; Mon, 22 Sep 2003 22:34:36 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 09882-05 for ; Mon, 22 Sep 2003 19:34:08 -0300 (ADT) Received: from krogh.officenet.no (cD90888A8.sdsl.catch.no [217.8.136.168]) by svr1.postgresql.org (Postfix) with ESMTP id 3AD49D1B50A for ; Mon, 22 Sep 2003 19:34:05 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by krogh.officenet.no (Postfix) with ESMTP id 9FD3173A01; Mon, 22 Sep 2003 18:34:06 -0400 (EDT) From: Andreas Joseph Krogh Organization: OfficeNet AS To: Tom Lane Subject: Re: Backup of multiple tables Date: Tue, 23 Sep 2003 00:34:00 +0200 User-Agent: KMail/1.5.9 Cc: pgsql-sql@postgresql.org References: <200309191354.06071.andreak@officenet.no> <20380.1063985897@sss.pgh.pa.us> In-Reply-To: <20380.1063985897@sss.pgh.pa.us> MIME-Version: 1.0 Content-Disposition: inline Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message-Id: <200309230034.06215.andreak@officenet.no> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/261 X-Sequence-Number: 15239 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Friday 19 September 2003 17:38, Tom Lane wrote: > Andreas Joseph Krogh writes: > > I usually backup my database with pg_backup without the -t option. But > > now I need to only backup certain tables(say tab1 and tab2), is this > > possible with pg_dump? I've tried with "pg_dump -t tab1 -t tab2" without > > success. > > pg_dump can only handle one -t option at a time. It'd make sense to > allow multiple -t options (likewise -n) but no one's got round to > improving the code in that particular direction. I don't think it would > be hard; want to fix it and send in a patch? I've never looked at the code-base of pgsql before, but I'll give it a try.= =20 Don't expect anything real soon tho. - --=20 Andreas Joseph Krogh Managing Director, Senior Software Developer OfficeNet AS - - Writing software is more fun than working. gpg public_key: http://dev.officenet.no/~andreak/public_key.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/b3jeUopImDh2gfQRAhP3AKCwsviN37+7ZAG4x4hI/ErQEyKmHACfW4on EI900FlO/lDInoDnf9nDEM0=3D =3DXcq/ -----END PGP SIGNATURE-----