Printing command string passed to EXECUTE command in plpgsql (after argument resolution)

Поиск
Список
Период
Сортировка
От Allan Kamau
Тема Printing command string passed to EXECUTE command in plpgsql (after argument resolution)
Дата
Msg-id AANLkTi=4_zpa-d6gqqQ+4cS6HSBAY6G138x-EGfjjXi1@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: maarten
Дата:
Сообщение: Re: PostGIS return multiple points
Следующее
От: "dan.m.harris"
Дата:
Сообщение: Re: Can't take base back up with Postgres 9.0 on Solaris 10