title: grant usage & privileges on future created schema in PostgreSQL
body: <p>The application I am integrating now will create new schemas. (each customer has its owned schema, eg. schema1, schema2, schema3 ....etc)
  To grant usage and read-only access to the new created schema and specific tables in the schema, I execute these commands:</p>
  
  <pre><code>GRANT USAGE ON SCHEMA schema1 TO read_only_user;
  GRANT SELECT ON schema1.talbe1 TO read_only_user;
  GRANT SELECT ON schema1.table2 TO read_only_user;
  
  GRANT USAGE ON SCHEMA schema2 TO read_only_user;
  GRANT SELECT ON schema2.talbe1 TO read_only_user;
  GRANT SELECT ON schema2.table2 TO read_only_user;
  
  (......and so on.....)
  </code></pre>
  
  <p>I just wonder if I could grant usage &amp; privileges on future created schema in PostgreSQL. Could only find ways to alter default privileges on future created tables but not future created schemas.</p>