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

Re: Pg_dump

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

In response to

  • Pg_dump at 2004-12-26 10:09:48 from Gourish Singbal

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2004-12-26 23:33:37
Subject: Re: Pg_dump
Previous:From: Bruno Wolff IIIDate: 2004-12-26 17:44:39
Subject: Re: database permissions:how to create read only user for db

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