pg tables

SELECT tablename AS TABLE FROM pg_tables WHERE schemaname = 'public';

select tablename, 
  HAS_TABLE_PRIVILEGE(tablename, 'select') as select,
  HAS_TABLE_PRIVILEGE(tablename, 'insert') as insert,
  HAS_TABLE_PRIVILEGE(tablename, 'update') as update,
  HAS_TABLE_PRIVILEGE(tablename, 'delete') as delete, 
  HAS_TABLE_PRIVILEGE(tablename, 'references') as references 
from pg_tables where schemaname='public' order by tablename;

See also

• Template:PosgreSQL