How to create an archive for old records?

From: "carter ck" <carterck32(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to create an archive for old records?
Date: 2007-02-15 01:11:42
Message-ID: BAY101-F7EE4E3DCE6FA1618DC7D0D5960@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I am looking for ways to create an archive of records older than 3 months in
one of my table, and store these extracted records into a local database.
Does Postgres have any command to do this?

Thanks.

_________________________________________________________________
Find just what you are after with the more precise, more powerful new
Windows Live Search. http://search.msn.com.sg/ Try it now.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brad Nicholson 2007-02-15 01:19:14 pg_dump and buffer usage
Previous Message madhtr 2007-02-14 23:24:59 Re: pqlib in c++: PQconnectStart PQconnectPoll