psql query to gave access to a database.public schema code example

Example: grant schema permissions postgres

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