在PostgreSQL中有查询来查看外包装的依赖吗？

作者: Gassyc加西可
发布时间: 2024-04-18 04:45:39 (7天前)
转自：

2 条回复

0#
回复此人
你咖喱人biss嗷 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 该查询产生外部表及其服务器： </p> <pre> <code> select n.nspname as "schema", c.relname as "table", s.srvname as "server", ft.ftoptions as "table options" from pg_foreign_table ft join pg_class c on c.oid = ft.ftrelid join pg_namespace n on n.oid = c.relnamespace join pg_foreign_server s on s.oid = ft.ftserver where pg_table_is_visible(c.oid) order by n.nspname, c.relname; </code> </pre> </DIV>

编辑

登录后才能参与评论