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.r@sbcglobal.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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] 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,
ifso 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/