Difference between revisions of "Pg tables"
Jump to navigation
Jump to search
(Created page with " select tablename, HAS_TABLE_PRIVILEGE(tablename, 'select') as select, HAS_TABLE_PRIVILEGE(tablename, 'insert') as insert, HAS_TABLE_PRIVILEGE(tablename, 'update')...") |
|||
Line 1: | Line 1: | ||
+ | {{lowercase}} | ||
+ | |||
+ | SELECT tablename AS TABLE FROM pg_tables WHERE schemaname = 'public'; | ||
Line 7: | Line 10: | ||
HAS_TABLE_PRIVILEGE(tablename, 'delete') as delete, | HAS_TABLE_PRIVILEGE(tablename, 'delete') as delete, | ||
HAS_TABLE_PRIVILEGE(tablename, 'references') as references | HAS_TABLE_PRIVILEGE(tablename, 'references') as references | ||
− | from pg_tables where schemaname='public' order by tablename; | + | from pg_tables where schemaname='public' order by tablename; |
+ | |||
+ | |||
+ | == See also == | ||
+ | * {{PosgreSQL}} |
Revision as of 09:35, 10 December 2021
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
Advertising: