Postgres Pro
Downloads
Home   >   mailing lists

Re: Backup the part of postgres database - Mailing list pgsql-general

From Shoaib Mir
Subject Re: Backup the part of postgres database
Date
Msg-id bf54be870701150140p32940b76y241078a9c4aba749@mail.gmail.com
Whole thread Raw
In response to Backup the part of postgres database  (roopa perumalraja <roopabenzer@yahoo.com>)
List pgsql-general
Tree view
COPY command might also help....

COPY (SELECT * FROM country WHERE country_name LIKE 'A%') TO '/usr1/proj/bray/sql/a_list_countries.copy';

Details can be found at --> http://www.postgresql.org/docs/current/static/sql-copy.html

------------------
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)

On 1/15/07, roopa perumalraja <roopabenzer@yahoo.com> wrote:
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.


pgsql-general by date:

Previous
From: "Philippe Lang"
Date:
Subject: Re: XEON familiy 5000, 5100 or 5300?
Next
From: "Jan van der Weijde"
Date:
Subject: Performance with very large tables