Re: Rationalizing EXPLAIN VERBOSE output

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Rationalizing EXPLAIN VERBOSE output
Date: 2002-03-11 02:28:49
Message-ID: 6268.1015813729@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Tom Lane writes:
>> ... How hard would it be to get psql to
>> send notice output into a \g file?

> \g (and \o) send only the query results to a file. The idea is that you
> want to save the results, but if there's a warning or error, you want to
> see it. We could add alternative commands (\G and \O?) that save the
> notices and errors as well. Not sure if this is useful beyond this
> application. In non-interactive situations you'd usually use shell
> redirections to save all output.

The other possibility is to make EXPLAIN output look like a SELECT
result. Not sure how hard this would be to do, but in the long run
I suppose that would be the direction to move in.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2002-03-11 02:32:02 Re: Allowing usernames in pg_hba.conf
Previous Message Peter Eisentraut 2002-03-11 02:25:44 Re: Rationalizing EXPLAIN VERBOSE output