From: | <msalais(at)msym(dot)fr> |
---|---|
To: | <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | values of column source in pg_settings |
Date: | 2025-09-10 19:21:10 |
Message-ID: | 04f101dc2288$121b2de0$365189a0$@msym.fr |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all,
I could find several distinct values for column "source" in pg_settings
view. Examples of these values are: client, environment variable,
configuration file, default, database, override, session.
Are there other values?
The documentation doesn't mention any thing (Any way I didn't find).
In some of my databases, I have this:
postgres# select name, source from pg_settings where source like 'environ%';
name | source
-----------------+----------------------
max_stack_depth | environment variable
What is the meaning of 'environment_variable' here?
For the other listed values, I have "almost" got it but I don't see anything
for "environment variable".
Thanks in advance
Michel SALAIS
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2025-09-10 19:39:09 | Re: values of column source in pg_settings |
Previous Message | Sachin Pawar | 2025-09-10 11:18:39 | Re: Post oracle to postgres migration verification |