Re: Archeiving and Purging

On 3/18/2015 7:20 AM, adityagis wrote:
>   I have lots of data in my DB. I need to do archeiving and purging of my
> data.
> Can anyone please help me with step by step riles?

like this?

select * from table where datefield < current_date-interval '6 months';
delete from table where datefield < current_date-interval '6 months';

obviously, save the data you selected in a suitable archive file. repeat
this for each table you wish to 'archive and purge'.

alter the interval with whatever criteria you want to use for this
archive and purge operation.





--
john r pierce, from the mid left coast