Version - 9.5
O/S - not applicable
SELECT set_config('davidj.testvar', 'value');
SELECT current_setting('davidj.testvar') --value
SELECT * FROM pg_settings WHERE name ~ 'testvar' --or ~davidj... either
way nothing shows
and:
SELECT current_setting('davidj.testvar2') -- unrecognized configuration
parameter
The underlying goal is to use the custom GUC within a CREATE VIEW in a
where clause. If the user issues a valid set_config for the GUC the query
is appropriately filtered otherwise I set things up so that particular
clause will not apply.
I've seen and can work with various work-arounds but it seems odd that
pg_settings doesn't show these custom GUCs.
Is there a simple way to read the value without receiving an error if the
value is missing?
David J.
