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 21A21D8416 for ; Tue, 25 Oct 2005 06:08:35 -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 51110-02 for ; Tue, 25 Oct 2005 09:08:30 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.207]) by svr1.postgresql.org (Postfix) with ESMTP id F3072D6EE1 for ; Tue, 25 Oct 2005 06:08:31 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 8so742331nzo for ; Tue, 25 Oct 2005 02:08:34 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=bhTfWXzysBWuYh3yQyXkQItMqoOFs5yu5PG5dQEozw3d/6dOgDnYg21647W4iN9BuUY3eMA/x3YZgkPgnTSBCoDNHvrVOAVQYJO5aZRIyVUL+P8AEtK3KYW1Mh6xfc/O/+m24KnwYH48UZYo0e92LwW2ej/npOF9xzsQYvioCnI= Received: by 10.37.2.10 with SMTP id e10mr37474nzi; Tue, 25 Oct 2005 02:08:33 -0700 (PDT) Received: by 10.36.68.17 with HTTP; Tue, 25 Oct 2005 02:08:33 -0700 (PDT) Message-ID: <674d1f8a0510250208q335a888fg61bac1b8c5a7bb9d@mail.gmail.com> Date: Tue, 25 Oct 2005 14:38:33 +0530 From: Gourish Singbal To: Colton A Smith Subject: Re: excluding a table from pg_dump Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3755_32990964.1130231313931" References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.119 required=5 tests=[AWL=0.008, HTML_40_50=0.086, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200510/258 X-Sequence-Number: 19330 ------=_Part_3755_32990964.1130231313931 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline pg_dump does not allow you to accomplish this task for sure. -- Best, Gourish Singbal On 10/20/05, Colton A Smith wrote: > > Hi: > > I don't think this is possible, but I want to make sure. Let's say I > have a database that I want to dump in its entirety, all except for one > particular table. Is there an option flag on pg_dump that accomplishes > this? > > Thanks again! > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > ------=_Part_3755_32990964.1130231313931 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
 
pg_dump does not allow you to accomplish this task for sure.

--
Best,
Gourish Singbal
 
On 10/20/05, Colton A Smith <smith@cs.utk.ed= u> wrote:
Hi:

  I don't t= hink this is possible, but I want to make sure.  Let's say I
h= ave a database that I want to dump in its entirety, all except for one
particular table. Is there an option flag on pg_dump that accomplishes<= br>this?

Thanks again!

---------------------------(end of bro= adcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster


------=_Part_3755_32990964.1130231313931--