Difference between revisions of "Pg tables"

From wikieduonline
Jump to navigation Jump to search
Line 16: Line 16:
 
== Related ==
 
== Related ==
 
* [[GRANT]]
 
* [[GRANT]]
* PG_TABLE_DEF
+
* [[PG_TABLE_DEF]]
  
 
== See also ==
 
== See also ==

Revision as of 12:11, 31 January 2022

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;

Related

See also

Advertising: