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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of roopa perumalraja Sent: Sunday, January 14, 2007 8:39 PM To: pgsql-general@postgresql.org 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 <http://us.rd.yahoo.com/evt=49938/*http://tools.search.yahoo.com/toolbar /features/mail/> email alerts with the free Yahoo! <http://us.rd.yahoo.com/evt=49938/*http://tools.search.yahoo.com/toolbar /features/mail/> Toolbar.
