ALTER DEFAULT PRIVILEGES

• https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO xxx;

ALTER DEFAULT PRIVILEGES
    [ FOR { ROLE | USER } target_role [, ...] ]
    [ IN SCHEMA schema_name [, ...] ]

See also

• ALTER, ALTER DATABASE, ALTER DEFAULT PRIVILEGES