values of column source in pg_settings

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

Responses

Browse pgsql-admin by date

  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