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 <[EMAIL PROTECTED]> 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<http://us.rd.yahoo.com/evt=49938/*http://tools.search.yahoo.com/toolbar/features/mail/>with
 the free Yahoo!
Toolbar.


Reply via email to