Ronen Nofar wrote:
> I have a weird case when running a query on the pg_settings view.
> I have two users, first one is the default user - postgres which is a superuser
> and another one is a role which i had created, i called it test_role and it's not a superuser.
> When I run a select on pg_settings with these two users I recieve different results.
That is intentional, because some settings should only be
visible for superusers, for example everything that has to
do with the operating system (location of configuration file
or socket directories).
Yours,
Laurenz Albe