Difference between revisions of "Information schema"

From wikieduonline
Jump to navigation Jump to search
Line 2: Line 2:
  
  
  select * from information_schema.[[role_table_grants]] where grantee='YOUR_USER';
+
  [[select]] * from information_schema.[[role_table_grants]] where grantee='YOUR_USER';
  
 
  grantor grantee .../...
 
  grantor grantee .../...
Line 10: Line 10:
 
* <code>[[psql -l]]</code>
 
* <code>[[psql -l]]</code>
  
 +
 +
{{SELECT}}
  
 
[[PostgreSQL: catalogs]]
 
[[PostgreSQL: catalogs]]

Revision as of 15:24, 15 December 2022


select * from information_schema.role_table_grants where grantee='YOUR_USER';
grantor grantee .../...


Relate


SELECT, GRANT SELECT ON, BETWEEN

PostgreSQL: catalogs

Advertising: