| From: | Bricklen Anderson <banderson(at)presinet(dot)com> |
|---|---|
| To: | Karthikeyan Sundaram <skarthi98(at)hotmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: pg_dump inquiry |
| Date: | 2007-02-28 23:05:08 |
| Message-ID: | 45E60AA4.5090504@presinet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Moginraj Mohandas | 2007-02-28 23:11:31 | please unsubscribe |
| Previous Message | Karthikeyan Sundaram | 2007-02-28 22:57:18 | pg_dump inquiry |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noura Elhawary | 2007-03-01 00:48:17 | what is the best way to get key information in postgres? |
| Previous Message | Karthikeyan Sundaram | 2007-02-28 22:57:18 | pg_dump inquiry |