Postgres Cheat Sheet

List the owners of all the databases:

select d.datname as "NAME", pg_catalog.pg_get_userbyid(d.datdba) as "Owner" FROM pg_catalog.pg_database d order by d.datname;

SELECT rolname FROM pg_roles;