Pg_dump

From: Gourish Singbal <gourish(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Pg_dump
Date: 2004-12-26 10:09:48
Message-ID: 674d1f8a04122602097b3fa678@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

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)

--
Best,
Gourish Singbal

Responses

  • Re: Pg_dump at 2004-12-26 17:47:10 from Bruno Wolff III

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2004-12-26 17:44:39 Re: database permissions:how to create read only user for db
Previous Message lexx 2004-12-26 07:41:22 Re: database permissions:how to create read only user for db