postgres script to grant select on all preexisting tables code example

Example: grant schema permissions postgres

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA schema_name TO username;