闪回有2个能力：闪回查询、闪回表 可参考 ://docs.opengauss.org/zh/docs/5.1.0/docs/DatabaseOMGuide/%E9%97%AA%E5%9B%9E%E6%81%A2%E5%A4%8D.html

1、闪回查询

--TIMECAPSULE { TIMESTAMP | CSN } expression 

SELECT * FROM table1 AS t TIMECAPSULE TIMESTAMP to_timestamp ('2026-01-01 10:08:00.000000', 'YYYY-MM-DD HH24:MI:SS.FF');
SELECT * FROM table1 AS t TIMECAPSULE CSN 1231;

2、闪回表

TIMECAPSULE TABLE   [schema.]table_name TO { CSN expr | TIMESTAMP expr | BEFORE { DROP [RENAME TO table_name] | TRUNCATE } };
TIMECAPSULE TABLE test TO TIMESTAMP to_timestamp ('2026-01-01 10:08:00.000000', 'YYYY-MM-DD HH24:MI:SS.FF');
TIMECAPSULE TABLE test TO BEFORE DROP;
TIMECAPSULE TABLE test TO BEFORE DROP RENAME TO test_new;

3、条件约束

show undo_retention_time; --用于设置旧版本undo的保留时间

show enable_recyclebin; --启用回收站
show recyclebin_retention_time; --设置回收站对象保留时间，超过该时间的回收站对象将被自动清理

select * from gs_recyclebin;--查看回收站中的内容