INSERT .into targettable. SELECT .. FROM destinationtable with filtered date
criteria.
DELETE FROM destinationtable with filtered date criteria.
Sreedhar
----- Original Message -----
From: "shoaib" <shoaibm@vmoksha.com>
To: "'Postgres general mailing list'" <pgsql-general@postgresql.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
>