Postgres Pro
Downloads
Home   >   mailing lists

Re: log_statement setting - Mailing list pgsql-general

From Jayadevan M
Subject Re: log_statement setting
Date
Msg-id CAFS1N4geWFJmu70rJeeKD5FH8utaXRa98KAjdnRWQDdjoEVCPw@mail.gmail.com
Whole thread Raw
In response to Re: log_statement setting  (Julien Rouhaud <rjuju123@gmail.com>)
List pgsql-general
Tree view


On Thu, Aug 19, 2021 at 11:41 AM Julien Rouhaud <rjuju123@gmail.com> wrote:

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.
Thank you.  Pointing to pg_db_role_setting was very helpful. I was able to get the data I wanted.
Regards,
Jay

pgsql-general by date:

Previous
From: Hispaniola Sol
Date:
Subject: Manual failover cluster
Next
From: Tom Lane
Date:
Subject: Re: Make bloom extension trusted, but can not drop with normal user