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.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
