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
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 |