Re: pg_dump inquiry

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.