How to access pg_settings from separate connection I am trying to access the pg_settings table from a separate connection belonging to a legacy application.

I know how to identify the connection's procid from pg_stat_activity, but I am unsure how to get to its pg_settings table from here.

I've checked pg_stat_all_tables, but that has no reference to any pg_settings tables.

information_schema.tables has a single row for pg_settings with table_type set to VIEW which indicates to me that I should be looking for a view rather than a table.

How can I access pg_settings belonging to a 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.