| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Gourish Singbal <gourish(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Pg_dump |
| Date: | 2004-12-26 17:47:10 |
| Message-ID: | 20041226174710.GB12115@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sun, Dec 26, 2004 at 15:39:48 +0530,
Gourish Singbal <gourish(at)gmail(dot)com> wrote:
> 1) I want to take a pg_dump of only few tables
>
> /usr/local/pgsql/bin/pg_dump -t [table_name] database_name > file.out
>
> allows me only to take dump of single table. Is there a way to take
> dump of more than one specific tables.
I think this is a new feature for 8.0.
> 2) Does pg_dump allow me to take dump of a table so that only some
> records are included in the dump (Some thing like specifying a QUERY
> in the pg_dump)
I suspect the best way to do this is to create a new table, select the desired
records into that table and then dump it.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-12-26 23:33:37 | Re: Pg_dump |
| Previous Message | Bruno Wolff III | 2004-12-26 17:44:39 | Re: database permissions:how to create read only user for db |