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

On Thursday 28. October 2010 16.25.47 Allan Kamau wrote:
> 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.

If I understand you correctly, you can assign the SQL string to a variable x,
and then do a RAISE NOTICE 'Query is: %', x

regards,
Leif B. Kristensen