Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





Alvaro Herrera wrote:
Luiz K. Matsumura wrote:
Hi all,

I want to suggest a inclusion of an new function on the pg_catalog.
Since we have set_config(text, text, boolean)
can we have an get_config( text ) ?

Hum, isn't this current_setting()?

Oh oh, you are right, forget my suggestion... :-[ I'm lost in the ocean of functions of pg_catalog. lol

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 ?

I'm just researching on a bug that i found in the new pgadmin3 and if this is equivalent i will suggest to pgadmin team to use it...

TIA


--
Luiz K. Matsumura
Plan IT Tecnologia Informática Ltda.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux