Re: Backup the part of postgres database

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(at)yahoo(dot)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<http://us.rd.yahoo.com/evt=49938/*http://tools.search.yahoo.com/toolbar/features/mail/>with the free Yahoo!
> Toolbar.
>
>