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.