Обсуждение: Getting the value of a config parameter in runtime

Hi all!

Sorry to ask this, I had it noted down but now I cannot find it and
I've been googling for 30 minutes now without success. There is a way
to query the system database to get the current value of a
configuration parameter, something in the form of SELECT value FROM
some_table WHERE field_name = 'archive_command', or similar, can't
remember, honestly. Or perhaps something more generic which was
filtered with greps, tails, heads and cuts.

Would someone be so kind as to point me at the right page or remind me
the way it was done?

Thanks in advance.

--
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"

You can configuration parameter value from psql prompt by typing
show all ;
or
show [paramter name]
e.g show shared_buffers;



Jaume Sabater wrote:
> Hi all!
>
> Sorry to ask this, I had it noted down but now I cannot find it and
> I've been googling for 30 minutes now without success. There is a way
> to query the system database to get the current value of a
> configuration parameter, something in the form of SELECT value FROM
> some_table WHERE field_name = 'archive_command', or similar, can't
> remember, honestly. Or perhaps something more generic which was
> filtered with greps, tails, heads and cuts.
>
> Would someone be so kind as to point me at the right page or remind me
> the way it was done?
>
> Thanks in advance.
>
>

Jaume Sabater a écrit :
> [...]
> Sorry to ask this, I had it noted down but now I cannot find it and
> I've been googling for 30 minutes now without success. There is a way
> to query the system database to get the current value of a
> configuration parameter, something in the form of SELECT value FROM
> some_table WHERE field_name = 'archive_command', or similar, can't
> remember, honestly. Or perhaps something more generic which was
> filtered with greps, tails, heads and cuts.
>
> Would someone be so kind as to point me at the right page or remind me
> the way it was done?
>

Table is pg_settings, and your field_name should be name.

Regards.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com