The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { safeSql } from '../pg-format'
export const FOREIGN_TABLES_SQL = /* SQL */ safeSql`
select
c.oid::int8 as id,
n.nspname as schema,
c.relname as name,
obj_description(c.oid) as comment,
fs.srvname as foreign_server_name,
fdw.fdwname as foreign_data_wrapper_name,
handler.proname as foreign_data_wrapper_handler
from
pg_class c
join pg_namespace n on n.oid = c.relnamespace
inner join pg_foreign_table ft on ft.ftrelid = c.oid
inner join pg_foreign_server fs on fs.oid = ft.ftserver
inner join pg_foreign_data_wrapper fdw on fdw.oid = fs.srvfdw
inner join pg_proc handler on handler.oid = fdw.fdwhandler
where
c.relkind = 'f'
`