<kynn@panix.com> writes:
> I.e. I'm looking for a way to grant SELECT privileges to PUBLIC on all
> the tables, without having to specify all the table names.
There isn't any direct way to do that, but various people have written
plpgsql functions that synthesize and execute all the required
individual GRANT commands. Dig around in the PG list archives ...
http://archives.postgresql.org/
regards, tom lane