Querying a custom postgresql parameter with SELECT statement

Question

In another question, it was asked how to query a postgresql runtime parameter (e.g. SHOW search_path;) using a SELECT query. In the answer, it was suggested to use

SELECT * FROM pg_settings WHERE name = 'search_path';

This works great, but how can this be done for custom parameters defined in an extension? (See docs about Customized Options).

Example:

SET abc.my_var = 1;
SHOW abc.my_var;

outputs

but

SELECT * FROM pg_settings WHERE name = 'abc.my_var';

returns no rows. Is there some other table/view I can query for my custom parameter using a SELECT statement?

user330315 · Accepted Answer · 2013-01-06 11:43:33Z

5

Use the function current_setting()

SELECT current_setting('abc.my_var');

http://www.postgresql.org/docs/current/static/functions-admin.html#FUNCTIONS-ADMIN-SET

answered Jan 6, 2013 at 11:43

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Querying a custom postgresql parameter with SELECT statement

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related