foreign-tables.ts21 lines · main

1	import { safeSql } from '../pg-format'
2
3	export const FOREIGN_TABLES_SQL = /* SQL */ safeSql`
4	select
5	c.oid::int8 as id,
6	n.nspname as schema,
7	c.relname as name,
8	obj_description(c.oid) as comment,
9	fs.srvname as foreign_server_name,
10	fdw.fdwname as foreign_data_wrapper_name,
11	handler.proname as foreign_data_wrapper_handler
12	from
13	pg_class c
14	join pg_namespace n on n.oid = c.relnamespace
15	inner join pg_foreign_table ft on ft.ftrelid = c.oid
16	inner join pg_foreign_server fs on fs.oid = ft.ftserver
17	inner join pg_foreign_data_wrapper fdw on fdw.oid = fs.srvfdw
18	inner join pg_proc handler on handler.oid = fdw.fdwhandler
19	where
20	c.relkind = 'f'
21	`