X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D59E0D94D6 for ; Thu, 22 Sep 2005 17:16:04 -0300 (ADT) 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 85459-10 for ; Thu, 22 Sep 2005 20:15:56 +0000 (GMT) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.195]) by svr1.postgresql.org (Postfix) with ESMTP id 79592D94DE for ; Thu, 22 Sep 2005 17:15:56 -0300 (ADT) Received: by xproxy.gmail.com with SMTP id i30so547233wxd for ; Thu, 22 Sep 2005 13:15:58 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ID7bt3DGP/K5rMIxF8VRj3iKjzsWXnQAOEhcqlI0tENObhIuabV2hFZtxAIMROoTog46Omi+tBk2OeUAeNLqvfqi3jxkzeM+E7pC+Mv+68BbI3QUXOd1S6Q18zS61VSr0sR0nie8ohss3lyYA3xWurrWUWvsAkrp8kMtzKsyM/o= Received: by 10.70.72.11 with SMTP id u11mr523135wxa; Thu, 22 Sep 2005 13:15:58 -0700 (PDT) Received: by 10.70.75.4 with HTTP; Thu, 22 Sep 2005 13:15:58 -0700 (PDT) Message-ID: Date: Fri, 23 Sep 2005 01:45:58 +0530 From: Rajesh Kumar Mallah Reply-To: Rajesh Kumar Mallah To: "Tomeh, Husam" Subject: Re: Backing up several tables using pg_dump -t Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.94 required=5 tests=[AWL=-0.916, RCVD_BY_IP=0.024, RCVD_IN_BL_SPAMCOP_NET=1.832] X-Spam-Level: X-Archive-Number: 200509/239 X-Sequence-Number: 18976 man pg_dump seems to say it is not possible -t table --table=3Dtable Dump data for table only. It is possible for there to be mul= ti- ple tables with the same name in different schemas; if that = is the case, all matching tables will be dumped. Specify b= oth --schema and --table to select just one table. Note: In this mode, pg_dump makes no attempt to dump any ot= her database objects that the selected table may depend upon. The= re- fore, there is no guarantee that the results of a single-ta= ble dump can be successfully restored by themselves into a cl= ean database. On 9/23/05, Tomeh, Husam wrote: > > I'm having problem backing up several tables using pg_dump. When > selecting one table only with the '-t' option, it works just fine. When > I tried to include several tables, pg_dump fails with error that the > tables specified don't exist. Can you show me an example of backing up > several tables using pg_dump. > > Thanks in advance, > > > -- > Husam > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > > ********************************************************************** > This message contains confidential information intended only for the > use of the addressee(s) named above and may contain information that > is legally privileged. If you are not the addressee, or the person > responsible for delivering it to the addressee, you are hereby > notified that reading, disseminating, distributing or copying this > message is strictly prohibited. If you have received this message by > mistake, please immediately notify us by replying to the message and > delete the original message immediately thereafter. > > Thank you. FADLD Tag > ********************************************************************** > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >