GaussDB(DWS)导出某张表依赖的视图定义

构建用例

create table t1(a int,b int);
create view v1 as select * from t1;
create view v2 as select * from v1;
create view v3 as select * from v2;

对象依赖视图

select * from gs_view_dependency_path;

依赖视图查询语句

WITH RECURSIVE view_deps AS (
    SELECT *
    FROM gs_view_dependency_path
    WHERE refobjschema = 'public' and refobjname = 't1' --替换为目标表
        UNION ALL
    SELECT gdp.*
    FROM gs_view_dependency_path gdp
    INNER JOIN view_deps v ON gdp.refobjschema = v.objschema and gdp.refobjname = v.objname
)
SELECT v.* FROM view_deps vd
JOIN pg_views v ON vd.objschema=v.schemaname and vd.objname = v.viewname;