Re: Backup the part of postgres database

["Adam Rich" <adam.r@xxxxxxxxxxxxx>]

Title: Message

Roopa,

You can use the command pg_dump to backup specific tables.   But you won't be able to

restrict the backup to specific rows.  (You can always create a separate table just for backups,

and dump just that table).

 

 

-----Original Message-----
From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of roopa perumalraja
Sent: Sunday, January 14, 2007 8:39 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: [GENERAL] Backup the part of postgres database

Hi all,

 

Is it possible to back up only part of my database for example from tables which have data from April to July 2006, if so what will be the command for that.

 

Thanks a lot in advance

Roopa

---

It's here! Your new message!
Get new email alerts with the free Yahoo! Toolbar.