[SQL] grant select on database demo to user

[Bryce Nesbitt]

I find myself with long lists of tables

  grant select on xx_tax to user;
  grant select on xx_trip to user;
  grant select on xx_foo to user;

Is there a way to grant to all tables, with a single grant?  I know how
to do it in mysql, but not postgres.  As close as I get it:

#grant select on database demo to user
ERROR:  invalid privilege type SELECT for database

-- 
----
Visit http://www.obviously.com/



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match