【openGauss】openGauss的dml恢复回滚

---

一、dml回滚

select * from aaa_test_1 timecapsule timestamp
to_timestamp('2024-02-05 17:40:08','YYYY-MM-DD HH24:MI:SS');

二、相关参数

– 设置闪回最长时间，undo_retention_time参数用于设置undo旧版本的保留时间。
show undo_retention_time;

四、查数据库权限

-- 查权限
select d.datname as "database",
        pg_catalog.pg_get_userbyid(d.datdba) as "Owner",
		d.datacl AS "Access privileges"
FROM pg_catalog.pg_database d;