从postgre中取出备份表的表名,并且删除30天以前的备份表
备份表
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),'y
原创
2012-02-15 16:30:15 ·
496 阅读 ·
0 评论