Using SHOW in PL/pgSQL

Started by Hans-Jürgen Schönigover 23 years ago2 messagesgeneral
Jump to latest
#1Hans-Jürgen Schönig
postgres@cybertec.at

Hi everybody

I have a brief question. It it just a simple yet annoying problem.
How can I use SHOW to retrieve a value inside a PL/pgSQL function?

I am looking for something like that:

SELECT enable_seqscan;

Is there a system table where I can find all the values on 7.2.3?
It seems as if there was no way to use SHOW in a subselect.

Any ideas to solve this problem efficiently.

Hans

--
*Cybertec Geschwinde u Schoenig*
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/1/913 68 09; +43/664/233 90 75
www.postgresql.at <http://www.postgresql.at&gt;, cluster.postgresql.at
<http://cluster.postgresql.at&gt;, www.cybertec.at
<http://www.cybertec.at&gt;, kernel.cybertec.at <http://kernel.cybertec.at&gt;

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Hans-Jürgen Schönig (#1)
Re: Using SHOW in PL/pgSQL

=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <hs@cybertec.at> writes:

I have a brief question. It it just a simple yet annoying problem.
How can I use SHOW to retrieve a value inside a PL/pgSQL function?

In 7.3 there are SQL function calls equivalent to SHOW and SET.
I think using those is probably the only way, short of hacking on
plpgsql.

regards, tom lane