Re: Explain

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Davis <jdavis(at)wasabimg(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Explain
Date: 2001-01-05 16:43:24
Message-ID: 10245.978713004@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeff Davis <jdavis(at)wasabimg(dot)com> writes:
> How can I conveniently handle output from an EXPLAIN query inside an
> application? It appears to just immediately send the output to the stdout of
> whatever program uses it. Is there a way to get the output inside a program,
> with libpq or otherwise?

The EXPLAIN result is sent as a NOTICE message, so you can trap it by
setting libpq's notice processor function --- see PQsetNoticeProcessor.

regards, tom lane

In response to

  • Explain at 2001-01-05 09:18:34 from Jeff Davis

Browse pgsql-general by date

  From Date Subject
Next Message martin.chantler 2001-01-05 16:48:09 Re: ODBC failure
Previous Message Tom Lane 2001-01-05 16:39:17 Re: select distinct null