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 <[EMAIL PROTECTED]> 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: [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 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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
