Re: How to create an archive for old records?

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: How to create an archive for old records?
Дата
Msg-id 45D3B579.5070601@cox.net
обсуждение исходный текст
Ответ на How to create an archive for old records?  ("carter ck" <carterck32@hotmail.com>)
Ответы Re: How to create an archive for old records?  (Paul Lambert <paul.lambert@autoledgers.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Brad Nicholson
Дата:
Сообщение: pg_dump and buffer usage
Следующее
От: Paul Lambert
Дата:
Сообщение: Re: How to create an archive for old records?