Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group