Re: Backup the part of postgres database

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(dot)r(at)sbcglobal(dot)net> 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(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of roopa perumalraja
> Sent: Sunday, January 14, 2007 8:39 PM
> To: pgsql-general(at)postgresql(dot)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/