Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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+
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #list #foreign #user #mapping #postgres
ADD COMMENT
Topic
Name
9+1 =