GRANT on database

Hi,

How do I grant all on database TO PUBLIC?
Without having to go through each table in that database?

Basically I have created a databases as one user, and I want another
user
to be able to access all tables in that database. However
when i run simple query like "SELECT * from tablename" as that "other
user"
it gives me (ERROR: tablename: Permission denied).

GRANT doesnt let you grant access to the entire databases , only tables.
and since I have over 30 tables in my DB goin through each table and
setting
permissions by hand is too time consuming.

Regards,
Boulat.

--
Nothing Like the Sun