Skip to content

Instantly share code, notes, and snippets.

@qdw

qdw/get_table_owner.sql

Created November 24, 2015 21:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save qdw/a559ca93546c29b41690 to your computer and use it in GitHub Desktop.
Save qdw/a559ca93546c29b41690 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
get_table_owner.sql
select pg_class.relname
from pg_class
join pg_roles on pg_class.relowner = pg_roles.oid
where pg_class.relname = 'ints';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment