Printing command string passed to EXECUTE command in plpgsql (after argument resolution) - Mailing list pgsql-general

From Allan Kamau
Subject Printing command string passed to EXECUTE command in plpgsql (after argument resolution)
Date
Msg-id AANLkTi=4_zpa-d6gqqQ+4cS6HSBAY6G138x-EGfjjXi1@mail.gmail.com
Whole thread Raw
Responses Re: Printing command string passed to EXECUTE command in plpgsql (after argument resolution)  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Printing command string passed to EXECUTE command in plpgsql (after argument resolution)  (Leif Biberg Kristensen <leif@solumslekt.org>)
List pgsql-general
I am debugging a plpgsql function which contains a long sql query
consisting of several parameters which is executed using EXECUTE
command. I would like to output this command string including the
actual values of the parameters contained within it so I can obtain
the actual query and run it directly (manually) in psql (or other
client such as pgAdmin3). Or at least is possible to output the
command string as is, followed by the parameter resolution details
such as $1='2', $2='abc' and so on.

Allan.

pgsql-general by date:

Previous
From: maarten
Date:
Subject: Re: PostGIS return multiple points
Next
From: "dan.m.harris"
Date:
Subject: Re: Can't take base back up with Postgres 9.0 on Solaris 10