【openGauss】openGauss误truncate表恢复
前提
回收站已开启
操作
/* 查回收站参数 */
select name,setting,unit,context from pg_settings where name ~* 'bin';
/* 查回收站对象 */
select * from my_recyclebin;
-- truncate \ drop
/* 恢复对象 */
TIMECAPSULE TABLE "BIN$4BE24EB5475$315BC00A480==$0" TO BEFORE TRUNCATE;
标签:name,truncate,恢复,select,openGauss,回收站
From: https://blog.csdn.net/tttzzzqqq2018/article/details/140642373