How to access pg_settings from separate connection
pg_settings is a view, not a table.

And every session has its own version of it. Per documentation:


  The change only affects the value used by the current session.


The attempt to access it from a different connection (session) is futile.