On Thu, Aug 19, 2021 at 1:55 PM Jayadevan M <maymala.jayadevan@xxxxxxxxx> wrote: > > Thank you. Follow up question- If it is set to different values for different users/databases, how can I get those values? For example, > I have a server with 4 databases. If I just query pg_settings, I get only one value. The value you see on pg_settings is the one that's selected for your current connection, based on the database/role you used. You can use \drds in psql to see the various configurations, or query the pg_db_role_setting table.
