Re: Suggestion for new function on pg_catalog: get_config()

Luiz K. Matsumura wrote:

> By the way,
>
> select setting AS default_tablespace from pg_show_all_settings() x(name
> text, setting text, unit text, category text, short_desc text, extra_desc
> text, context text, vartype text, source text, min_val text, max_val text)
> where name = 'default_tablespace'
>
> and
>
> select current_setting('default_tablespace' )
>
> can be considered equivalent ?

Probably. Also try
select * from pg_settings;

--
Alvaro Herrera Developer, http://www.PostgreSQL.org/
"Industry suffers from the managerial dogma that for the sake of stability
and continuity, the company should be independent of the competence of
individual employees." (E. Dijkstra)