Difference between revisions of "Information schema"

From wikieduonline
Jump to navigation Jump to search
Line 4: Line 4:
 
  select * from information_schema.[[role_table_grants]] where grantee='YOUR_USER';
 
  select * from information_schema.[[role_table_grants]] where grantee='YOUR_USER';
  
 +
grantor grantee .../...
  
[[psql -l]]
+
 
 +
== Relate ==
 +
* <code>[[psql -l]]</code>
  
  
 
[[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


PostgreSQL: catalogs

Advertising: