Re: Bulk coying of data from one table to another

INSERT .into targettable. SELECT .. FROM destinationtable with filtered date
criteria.
DELETE FROM destinationtable with filtered date criteria.

Sreedhar
----- Original Message -----
From: "shoaib" <shoaibm(at)vmoksha(dot)com>
To: "'Postgres general mailing list'" <pgsql-general(at)postgresql(dot)org>
Sent: Monday, June 02, 2003 4:01 PM
Subject: [GENERAL] Bulk coying of data from one table to another

> Hello All,
>
> I want to run a process of archival which will delete data form one
> table and insert into another based on date critria.
>
> Can anybody please guide what will be best way of doing it.
>
> Regards
>
> Shoaib
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>