Answers for "list foreign user mapping postgres"

SQL
0

list foreign user mapping postgres

SELECT um.*,rolname
  FROM pg_user_mapping um
  JOIN pg_roles r ON r.oid = umuser
  JOIN pg_foreign_server fs ON fs.oid = umserver;

(or in psql)
\deu+
Posted by: Guest on March-11-2022

Code answers related to "SQL"

Browse Popular Code Answers by Language