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 076CFD9043 for ; Tue, 25 Oct 2005 06:40:40 -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 55292-10 for ; Tue, 25 Oct 2005 09:40:36 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 28F1CD7292 for ; Tue, 25 Oct 2005 06:40:38 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j9P9ea73061569 for ; Tue, 25 Oct 2005 09:40:36 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j9P9VH8C059161 for pgsql-admin@postgresql.org; Tue, 25 Oct 2005 09:31:17 GMT (envelope-from news) From: Hannes Dorbath X-Newsgroups: pgsql.admin Subject: Re: excluding a table from pg_dump Date: Tue, 25 Oct 2005 11:31:51 +0200 Organization: Hub.Org Networking Services Lines: 16 Message-ID: References: <674d1f8a0510250208q335a888fg61bac1b8c5a7bb9d@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.4 (Windows/20050908) In-Reply-To: <674d1f8a0510250208q335a888fg61bac1b8c5a7bb9d@mail.gmail.com> To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.434 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.386] X-Spam-Level: X-Archive-Number: 200510/259 X-Sequence-Number: 19331 It's possible with pg_restore to exclude that table on /restore/, but that's not what you asked for.. On 25.10.2005 11:08, Gourish Singbal wrote: > pg_dump does not allow you to accomplish this task for sure. > > On 10/20/05, Colton A Smith wrote: >> 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? -- Regards, Hannes Dorbath