Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C3EED9FBB31 for ; Thu, 1 Mar 2007 11:26:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 94349-05 for ; Thu, 1 Mar 2007 11:26:39 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtp101.plus.mail.mud.yahoo.com (smtp101.plus.mail.mud.yahoo.com [68.142.206.234]) by postgresql.org (Postfix) with SMTP id 69E2D9FBAD6 for ; Thu, 1 Mar 2007 11:26:45 -0400 (AST) Received: (qmail 58477 invoked from network); 1 Mar 2007 15:26:43 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=Received:X-YMail-OSG:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding; b=itGVuY/+CKzSF9vscdiHf8VBnwcYufoGoBk4euo64S8LAUn+ywiSd7rZDewB6nt+Y4q7LQbaIOdznL+2IO61TZhoW+gjApBJgfmzMgXr+zKATgg1SXRXQbbNXYmiVkrxmUmVqhYg0uEm4XL8RIpz9QUGfU8r/wjhrRLO5qB1jKo= ; Received: from unknown (HELO ?10.2.200.151?) (osvaldo_kussama@200.155.30.180 with plain) by smtp101.plus.mail.mud.yahoo.com with SMTP; 1 Mar 2007 15:26:42 -0000 X-YMail-OSG: nF70F1MVM1lYbIkKIo5bDfV.cTZlSZ9UKc9v6.s6wK87a1TT7RSi0NXVAs7E58RbsqsIQJ61RfKkjUhm6sNDYlQEEhoDOlB1.Ge8nQPG1xFe16wqngvxdW5FyUDRL9fkSqdPZTSzF5iGYyY- Message-ID: <45E6F1A6.2000909@yahoo.com.br> Date: Thu, 01 Mar 2007 12:30:46 -0300 From: Osvaldo Rosario Kussama User-Agent: Thunderbird 1.5.0.9 (X11/20070102) MIME-Version: 1.0 To: Karthikeyan Sundaram , pgsql-sql@postgresql.org Subject: Re: pg_dump inquiry References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.344 tagged_above=0 required=5 tests=AWL, BAYES_50, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200703/14 X-Sequence-Number: 27652 Karthikeyan Sundaram escreveu: > Hi, > > I have to dump only 10 tables out of 100 tables. In the pg_dump > utility given by postgres there is an option called -t followed by table > name. > > In that option, if I give more than 1 table, it's not accepting. > > How can I get the dump in one stroke for all the 10 tables? Please > advise. > http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html "Multiple tables can be selected by writing multiple -t switches. Also, the table parameter is interpreted as a pattern according to the same rules used by psql's \d commands (see Patterns), so multiple tables can also be selected by writing wildcard characters in the pattern." []s Osvaldo _______________________________________________________ Yahoo! Mail - Sempre a melhor opção para você! Experimente já e veja as novidades. http://br.yahoo.com/mailbeta/tudonovo/