Pg tables

From wikieduonline
Revision as of 09:34, 10 December 2021 by Welcome (talk | contribs) (Created page with " select tablename, HAS_TABLE_PRIVILEGE(tablename, 'select') as select, HAS_TABLE_PRIVILEGE(tablename, 'insert') as insert, HAS_TABLE_PRIVILEGE(tablename, 'update')...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


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;

Advertising: