| From: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
|---|---|
| To: | Jayadevan M <maymala(dot)jayadevan(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-19 06:10:55 |
| Message-ID: | CAOBaU_a4BxcqkY293oBuf1kz6p+Xp1mm_n7kXpSVp+5KqAHarA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Aug 19, 2021 at 1:55 PM Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markhof, Ingolf | 2021-08-19 11:48:20 | Regexp_replace bug / does not terminate on long strings |
| Previous Message | Jayadevan M | 2021-08-19 05:54:45 | Re: log_statement setting |