Goal Find all user mappings for foreign servers and tables
Type General (Overview of some aspect of the database.)
License MIT License
Data Source system catalog only
SQL Query
SELECT srvname AS server_name, usename, 
CASE WHEN regexp_replace(umoptions::text, 'password=[^,]*', 'password=salajane', 'g') NOT LIKE '%}'
THEN regexp_replace(umoptions::text, 'password=[^,]*', 'password=salajane', 'g') || '}'
ELSE regexp_replace(umoptions::text, 'password=[^,]*', 'password=salajane', 'g')  END AS umoptions
FROM pg_user_mappings
ORDER BY srvname, usename;

Collections

This query belongs to the following collections:

NameDescription
Find problems by overviewQueries that results point to different aspects of database that might have problems. A human reviewer has to decide based on the results as to whether there are problems or not .
Categories

This query is classified under the following categories:

NameDescription
Distributed databaseQueries of this category provide information about the foreign table mechanism.