As for me easier is
SELECT current_setting( 'shared_buffers' ), current_setting( 'data_directory' ), ...
One row and you know which column is which setting.
BTW, Johann (sorry for public, but don't know how to reach you in other way. Could not send directly to you because of "The error that the other server returned was: 550 550 <
johann@2ndquadrant.com>: quota exceeded (state 13).")
Best regards, Vitalii Tymchyshyn.
2012/6/8 Johann 'Myrkraverk' Oskarsson
<johann@2ndquadrant.com>Craig Ringer <
ringerc@ringerc.id.au> writes:
> The JDBC driver really needs a way to grab everything it needs to know
> efficiently during initial connection setup, with some extensibility
> so connection parameters can specify other things to request and cache
> when the connection is first established.
SELECT current_setting( 'shared_buffers' )
UNION
SELECT current_setting( 'data_directory' );
for some randomly chosen settings? Of course the query will need to be
structured with key/values to be useful.
--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/
--
Best regards,
Vitalii Tymchyshyn