title: postgresql - view schema privileges
body: <p>Is there a query I can run to show currently assigned privileges on a particular schema?</p>
  
  <p>i.e. privileges that were assigned like so:</p>
  
  <pre><code>GRANT USAGE ON SCHEMA dbo TO MyUser
  </code></pre>
  
  <p>I have tried</p>
  
  <pre><code>SELECT *
  FROM information_schema.usage_privileges;
  </code></pre>
  
  <p>but this only returns grants to the built-in PUBLIC role. Instead, I want to see which users have been granted privileges on the various schema.</p>
  
  <p>Note: I'm actually using Amazon Redshift rather than pure PostgreSQL, although I will accept a pure PostgreSQL answer if this is not possible in Amazon Redshift. (Though I suspect it is)</p>