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 9FAFBD9118 for ; Thu, 22 Sep 2005 18:30:12 -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 22094-05 for ; Thu, 22 Sep 2005 21:30:08 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id B7259D9238 for ; Thu, 22 Sep 2005 18:30:09 -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 j8MLU8lV024604 for ; Thu, 22 Sep 2005 21:30:08 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j8ML7Lwv018362 for pgsql-admin@postgresql.org; Thu, 22 Sep 2005 21:07:21 GMT (envelope-from news) Date: Thu, 22 Sep 2005 23:07:22 +0200 From: Hannes Dorbath User-Agent: Thunderbird 1.4 (Windows/20050908) MIME-Version: 1.0 X-Newsgroups: pgsql.admin Subject: Re: Backing up several tables using pg_dump -t References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Lines: 10 Message-ID: <4333151c$0$3712$8fe63b2a@news.disputo.net> Organization: FirstUseNet Intermedia GmbH X-Complaints-To: abuse@disputo.de To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.459 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.361] X-Spam-Level: X-Archive-Number: 200509/242 X-Sequence-Number: 18979 On 22.09.2005 21:38, Tomeh, Husam wrote: > Can you show me an example of backing up several tables using pg_dump. I'd just warp pg_dump in a little (shell-)script or dump all tables and pass pg_restore a TOC list (-L option) of objects I want. -- Regards, Hannes Dorbath