Re: show() function

Rod Taylor wrote:
>>test=# show all;
>> name | setting
>>-------------------------------+---------------------------------------
>> australian_timezones | off
>> authentication_timeout | 60
>
>
>
> Does this mean I could capture the output? I.e. Does anything special
> need to happen to have JDBC and friends return a vector with the info?
>

I'm not sure how the various interfaces will handle this. I have an SRF
in the form of a contrib function that I'm sure will work with any
interface, but I have yet to get it accepted into cvs for a variety of
reasons. That's the contib/showguc show_all_vars() function I referred
in the post you are replying to. E.g.:

test=# select * from show_all_vars();
varname | varval
-------------------------------+---------------------------------------
australian_timezones | off
authentication_timeout | 60
checkpoint_segments | 3
.
.
.
wal_debug | 0
wal_files | 0
wal_sync_method | fdatasync
(96 rows)

I *think* this function, probably renamed, will end up in
contrib/tablefunc or something similar.

Joe