postgresql access privileges to schema code example

Example 1: user privileges postgresql information_schema

GRANT SELECT ON ALL TABLES IN SCHEMA PUBLIC TO testuser2;

Example 2: grant schema permissions postgres

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