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); > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]