Bruce Momjian <bruce@xxxxxxxxxx> 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. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
