SHOW ALL as a query result - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject SHOW ALL as a query result
Date
Msg-id GNELIHDDFBOCMGBFGEFOGEPACBAA.chriskl@familyhealth.com.au
Whole thread Raw
Responses Re: SHOW ALL as a query result  (Peter Eisentraut <peter_e@gmx.net>)
Re: SHOW ALL as a query result  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Hi All,

Now that Tom's modified the EXPLAIN output to appear as a query result,
maybe SHOW and SHOW ALL should also be modified in that way.  The current
NOTICE: business is a bit messy, and it sure would assist projects just as
pgAccess, phpPgAdmin and pgAdmin with displaying configuration!

Also, what else could be usefully modified?

Chris

ps.

>>BTW, see: ~/pgsql/src/backend/commands/explain.c
>>for the new functions Tom Lane wrote which send explain results to the
>>front end as if they were from a select statement. Very informative.
>>Specifically see:
>>     begin_text_output(CommandDest dest, char *title);
>>     do_text_output(TextOutputState *tstate, char *aline);
>>     do_text_output_multiline(TextOutputState *tstate, char *text);
>>     end_text_output(TextOutputState *tstate);
>



pgsql-hackers by date:

Previous
From: Gavin Sherry
Date:
Subject: Re: Suggestions please: names for function cachability
Next
From: Neil Conway
Date:
Subject: Re: ANALYZE after restore