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 BDD13D1B50F for ; Fri, 19 Sep 2003 15:38:30 +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 73495-06 for ; Fri, 19 Sep 2003 12:38:20 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id C2BADD1B500 for ; Fri, 19 Sep 2003 12:38:19 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id h8JFcHiP020381; Fri, 19 Sep 2003 11:38:17 -0400 (EDT) To: Andreas Joseph Krogh Cc: pgsql-sql@postgresql.org Subject: Re: Backup of multiple tables In-reply-to: <200309191354.06071.andreak@officenet.no> References: <200309191354.06071.andreak@officenet.no> Comments: In-reply-to Andreas Joseph Krogh message dated "Fri, 19 Sep 2003 13:54:01 +0200" Date: Fri, 19 Sep 2003 11:38:17 -0400 Message-ID: <20380.1063985897@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/201 X-Sequence-Number: 15179 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? regards, tom lane