From: Osvaldo Rosario Kussama <osvaldo_kussama@yahoo.com.br>
To: Karthikeyan Sundaram <skarthi98@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: pg_dump inquiry
Date: Thu, 01 Mar 2007 12:30:46 -0300
Message-ID: <45E6F1A6.2000909@yahoo.com.br> (raw)
In-Reply-To: <BAY131-F119CCDEEE689FAB33DADA3B0810@phx.gbl>
References: <BAY131-F119CCDEEE689FAB33DADA3B0810@phx.gbl>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: osvaldo_kussama@yahoo.com.br, skarthi98@hotmail.com
Subject: Re: pg_dump inquiry
In-Reply-To: <45E6F1A6.2000909@yahoo.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox