diag_fdw.sql
401 Bytes
-- Diagnóstico de Servidores Extranjeros
SELECT srvname, srvoptions FROM pg_foreign_server WHERE srvname = 'srv_mun_1109';
-- Diagnóstico de Mapeo de Usuarios (Solo opciones para ver credenciales aplicadas)
SELECT u.usename, s.srvname, um.umoptions
FROM pg_user_mappings um
JOIN pg_foreign_server s ON um.srvid = s.srvid
JOIN pg_user u ON um.umid = u.usesysid
WHERE s.srvname = 'srv_mun_1109';