Re: Pg_dump

On Sun, Dec 26, 2004 at 15:39:48 +0530,
  Gourish Singbal <gourish@gmail.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.