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:
