Difference between revisions of "Information schema"

From wikieduonline
Jump to navigation Jump to search
 
(5 intermediate revisions by 2 users not shown)
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 .../...
  
[[psql -l]]
 
  
 +
== Related ==
 +
* <code>[[psql -l]]</code>
 +
* <code>[[ERROR: permission denied for your-table]]</code>
  
[[PostgreSQL: catalogs]]
+
== See also ==
 +
* {{SELECT}}
 +
 
 +
[[Category:PostgreSQL]]

Latest revision as of 15:26, 15 December 2022


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


Related[edit]

See also[edit]

Advertising: