roopa perumalraja wrote: > Hi Adam, > > Thanks a lot for your immediate reply. can you please tell me how to use the command pg_dump to backup specific tables. Thanks a lot in advance. pg_dump --help > > Regards > Roopa > > Adam Rich <adam.r@xxxxxxxxxxxxx> wrote: > 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. > > > --------------------------------- > Bored stiff? Loosen up... > Download and play hundreds of games for free on Yahoo! Games. -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/
