Postgres: To list table owners
SELECT schemaname, tablename, tableowner
FROM pg_tables
WHERE schemaname NOT IN ('pg_catalog', 'information_schema')
ORDER BY tableowner, schemaname, tablename;
----
SELECT schemaname, tablename, tableowner
FROM pg_tables
WHERE schemaname <> tableowner
AND schemaname NOT IN ('pg_catalog', 'information_schema')
ORDER BY tableowner, schemaname, tablename;
Comments
Post a Comment