getting EXPLAIN output from inside a function - Mailing list pgsql-general

From Joseph S
Subject getting EXPLAIN output from inside a function
Date
Msg-id iopto2$1dc9$1@news.hub.org
Whole thread Raw
List pgsql-general
I saw this in the mailing list archives without an answer, so for future
reference:

DECLARE
...
   line TEXT;
BEGIN
...
  FOR line IN  EXECUTE ''EXPLAIN ANALYZE <statement goes here> LOOP
                       RAISE NOTICE ''% '' , line;
              END LOOP;

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: problem with parent/child table and FKs
Next
From: Scott Marlowe
Date:
Subject: Re: SSDs with Postgresql?