SHOW ALL as a query result

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <peter_e(at)gmx(dot)net>
Subject: SHOW ALL as a query result
Date: 2002-04-03 01:49:32
Message-ID: GNELIHDDFBOCMGBFGEFOGEPACBAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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);
>

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2002-04-03 01:51:47 Re: ANALYZE after restore
Previous Message Gavin Sherry 2002-04-03 01:47:29 Re: Suggestions please: names for function cachability