Using SHOW in PL/pgSQL - Mailing list pgsql-general

From Hans-Jürgen Schönig
Subject Using SHOW in PL/pgSQL
Date
Msg-id 3DDDE9B6.80904@cybertec.at
Whole thread Raw
Responses Re: Using SHOW in PL/pgSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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>, cluster.postgresql.at
<http://cluster.postgresql.at>, www.cybertec.at
<http://www.cybertec.at>, kernel.cybertec.at <http://kernel.cybertec.at>


pgsql-general by date:

Previous
From: 史绪良
Date:
Subject: consultation!
Next
From: MT
Date:
Subject: Select nextval problem