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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
