title: Grant privileges on future tables in PostgreSQL?
body: <p>I am running PostgreSQL 9.3.1. I have <code>test</code> database and <code>backup</code> user which is used to backup the database. I have no problems with granting privileges to all current tables, but I have to grant privileges each time the new table is added to schema.</p>
  
  <pre><code>createdb test
  
  psql test
  test=# create table foo();
  CREATE TABLE
  test=# grant all on all tables in schema public to backup;
  GRANT
  test=# create table bar();
  CREATE TABLE
  
  psql -U backup test
  test=&gt; select * from foo;
  test=&gt; select * from bar;
  ERROR:  permission denied for relation bar
  </code></pre>
  
  <p>Is it possible to grant access to tables which will be created in future without making user owner of the table?</p>