Table owners postgres

TableOwners.sql

-- Get owners of schema
SELECT
	nsp.nspname AS the_schema,
	rol.rolname AS the_owner
FROM
	pg_namespace nsp
	JOIN pg_roles rol ON rol.oid = nsp.nspowner
WHERE
	nsp.nspname = 'public';



-- Get owners of tables
select nsp.nspname as object_schema,
       cls.relname as object_name, 
       rol.rolname as owner, 
       case cls.relkind
         when 'r' then 'TABLE'
         when 'm' then 'MATERIALIZED_VIEW'
         when 'i' then 'INDEX'
         when 'S' then 'SEQUENCE'
         when 'v' then 'VIEW'
         when 'c' then 'TYPE'
         else cls.relkind::text
       end as object_type
from pg_class cls
  join pg_roles rol on rol.oid = cls.relowner
  join pg_namespace nsp on nsp.oid = cls.relnamespace
where nsp.nspname not in ('information_schema', 'pg_catalog')
  and nsp.nspname not like 'pg_toast%'
  -- and rol.rolname = current_user  --- remove this if you want to see all objects
order by nsp.nspname, cls.relname;