Skip to content

Instantly share code, notes, and snippets.

@mandeepbal

mandeepbal/gist:2213a8d1a98c5bcf9a16

Created September 11, 2014 14:59
Show Gist options
  • Save mandeepbal/2213a8d1a98c5bcf9a16 to your computer and use it in GitHub Desktop.
Save mandeepbal/2213a8d1a98c5bcf9a16 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres Queries
Raw
gistfile1.txt
#Get list database owners
SELECT d.datname as "Name",
pg_catalog.pg_get_userbyid(d.datdba) as "Owner"
FROM pg_catalog.pg_database d
ORDER BY 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment