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.
In response to
- Pg_dump at 2004-12-26 10:09:48 from Gourish Singbal
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2004-12-26 23:33:37|
|Subject: Re: Pg_dump |
|Previous:||From: Bruno Wolff III||Date: 2004-12-26 17:44:39|
|Subject: Re: database permissions:how to create read only user for db|