| From: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: return text from explain |
| Date: | 2012-09-07 08:40:34 |
| Message-ID: | CAHnozTjpWd+xvdo5vtEweNQGJq6ArLCq56C16jmAkC1cqwuBrQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Sep 6, 2012 at 10:15 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > On Thu, Sep 6, 2012 at 07:18:50PM +0200, Willy-Bas Loos wrote:
> >> Is it possible to use the output of explain as text values?
>
> > I think you have to do EXPLAIN in a function and call the function.
>
> Yeah, IIRC you can use EXPLAIN as the source statement in a plpgsql
> FOR loop, ie
> FOR text_variable IN EXPLAIN ... LOOP
> which gets you the output one line at a time.
>
>
nope,
ERROR: syntax error at or near "explain"
that's postgres 9.1
WBL
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Виктор Егоров | 2012-09-07 09:00:14 | Re: return text from explain |
| Previous Message | Stuart Bishop | 2012-09-07 06:39:45 | Re: pg_dump on hot standby canceled despite hot_standby_feedback=on |