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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
