Re: How to create an archive for old records? - Mailing list pgsql-general

From Ron Johnson
Subject Re: How to create an archive for old records?
Date
Msg-id 45D3B579.5070601@cox.net
Whole thread Raw
In response to How to create an archive for old records?  ("carter ck" <carterck32@hotmail.com>)
Responses Re: How to create an archive for old records?  (Paul Lambert <paul.lambert@autoledgers.com.au>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 02/14/07 19:11, carter ck wrote:
> 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?

A single command that will copy data to a destination database, and
then delete from the source database?

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFF07V5S9HxQb37XmcRAmcmAKCBRmyMFbhnfC04VUwI29pUDEVpzgCdGeDi
ZqGkW48PU/99qt9bs0waftA=
=V7r+
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Brad Nicholson
Date:
Subject: pg_dump and buffer usage
Next
From: Paul Lambert
Date:
Subject: Re: How to create an archive for old records?