备份表
table_name_20120101
table_name_20120102
table_name_20120103
select relname
from pg_class where relname like 'table_name_20%' and
to_date(substring(replace(relname,'table_name_',''),1,8),'yyyymmdd') <= now() + '-30 days';
备份表
table_name_20120101
table_name_20120102
table_name_20120103
select relname
from pg_class where relname like 'table_name_20%' and
to_date(substring(replace(relname,'table_name_',''),1,8),'yyyymmdd') <= now() + '-30 days';