Pg_db_role_setting
List Per-Role and Database Settings with pg_db_role_setting
Oct 27, 2026 / · 12 min read · alter role alter database configuration psql work_mem statement_timeout pg_db_role_setting pg_database pg_roles ·List Per-Role and Database Settings with pg_db_role_setting A reporting user logs in and gets a work_mem that matches nothing in postgresql.conf. On the same server, statement_timeout differs between two databases, and neither value is in a file. In PostgreSQL, ALTER ROLE ... SET and ALTER DATABASE ... SET store their …
Read More