pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump inquiry
4+ messages / 4 participants
[nested] [flat]
* pg_dump inquiry
@ 2007-02-28 22:57 Karthikeyan Sundaram <skarthi98@hotmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Karthikeyan Sundaram @ 2007-02-28 22:57 UTC (permalink / raw)
To: pgsql-admin@postgresql.org; pgsql-sql
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.
Regards
skarthi
_________________________________________________________________
Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month.
Intro*Terms
https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search=mortgage_te...
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_dump inquiry
@ 2007-02-28 23:05 Bricklen Anderson <banderson@presinet.com>
parent: Karthikeyan Sundaram <skarthi98@hotmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Bricklen Anderson @ 2007-02-28 23:05 UTC (permalink / raw)
To: Karthikeyan Sundaram <skarthi98@hotmail.com>; +Cc: pgsql-admin@postgresql.org
Karthikeyan Sundaram wrote:
> 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.
>
> Regards
> skarthi
If you are using postgresql 8.2, you can specify multiple tables
http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html
Don't think that that was possible before 8.2, though.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_dump inquiry
@ 2007-03-01 15:30 Osvaldo Rosario Kussama <osvaldo_kussama@yahoo.com.br>
parent: Karthikeyan Sundaram <skarthi98@hotmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Osvaldo Rosario Kussama @ 2007-03-01 15:30 UTC (permalink / raw)
To: Karthikeyan Sundaram <skarthi98@hotmail.com>; pgsql-sql
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/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_dump inquiry
@ 2007-03-01 15:49 Joe <dev@freedomcircle.net>
parent: Osvaldo Rosario Kussama <osvaldo_kussama@yahoo.com.br>
0 siblings, 0 replies; 4+ messages in thread
From: Joe @ 2007-03-01 15:49 UTC (permalink / raw)
To: Osvaldo Rosario Kussama <osvaldo_kussama@yahoo.com.br>; +Cc: Karthikeyan Sundaram <skarthi98@hotmail.com>; pgsql-sql
On Thu, 2007-03-01 at 12:30 -0300, Osvaldo Rosario Kussama wrote:
> 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."
But note that this is a new feature in 8.2. In 8.1 and earlier,
multiple -t switches will only get you the last one specified.
Joe
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2007-03-01 15:49 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-02-28 22:57 pg_dump inquiry Karthikeyan Sundaram <skarthi98@hotmail.com>
2007-02-28 23:05 ` Bricklen Anderson <banderson@presinet.com>
2007-03-01 15:30 ` Osvaldo Rosario Kussama <osvaldo_kussama@yahoo.com.br>
2007-03-01 15:49 ` Joe <dev@freedomcircle.net>
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