Difference between revisions of "Pg tables"

From wikieduonline
Jump to navigation Jump to search
Line 18: Line 18:
 
* [[PG_TABLE_DEF]]
 
* [[PG_TABLE_DEF]]
 
* [[SORTKEY]]
 
* [[SORTKEY]]
 +
* <code>[[pg_database_size]]</code>
  
 
== See also ==
 
== See also ==

Revision as of 22:30, 6 June 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: