在PostgreSQL中有没有一种方法可以找到所有使用外部数据包装器的视图？

SELECT c.relname AS view_name, n.nspname AS schema_name
FROM pg_class c
JOIN pg_namespace n ON c.relnamespace = n.oid
JOIN pg_rewrite r ON c.oid = r.ev_class
JOIN pg_depend d ON r.oid = d.objid
JOIN pg_extension e ON d.refobjid = e.oid
WHERE c.relkind = 'v' AND e.extname = 'postgres_fdw';

SELECT pg_get_viewdef(c.oid) AS view_definition, c.relname AS view_name, n.nspname AS schema_name
FROM pg_class c
JOIN pg_namespace n ON c.relnamespace = n.oid
JOIN pg_rewrite r ON c.oid = r.ev_class
JOIN pg_depend d ON r.oid = d.objid
JOIN pg_extension e ON d.refobjid = e.oid
WHERE c.relkind = 'v' AND e.extname = 'postgres_fdw';