| From: | Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com> |
|---|---|
| To: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: log_statement setting |
| Date: | 2021-08-20 13:25:23 |
| Message-ID: | CAFS1N4geWFJmu70rJeeKD5FH8utaXRa98KAjdnRWQDdjoEVCPw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Aug 19, 2021 at 11:41 AM Julien Rouhaud <rjuju123(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-08-20 13:26:11 | Re: Make bloom extension trusted, but can not drop with normal user |
| Previous Message | Hispaniola Sol | 2021-08-20 12:48:43 | Manual failover cluster |