On Thu, Aug 19, 2021 at 1:55 PM Jayadevan M <maymala.jayadevan@gmail.com> 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.
