Re: Mimic parse bind execute in psql?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Mimic parse bind execute in psql?
Дата
Msg-id 21731.1514564465@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Mimic parse bind execute in psql?  (Jeremy Finzel <finzelj@gmail.com>)
Список pgsql-general
Jeremy Finzel <finzelj@gmail.com> writes:
> If I want to mimic a log statement that is from an application that uses
> PARSE/BIND/EXECUTE, is there any way to mimic this behavior in psql, for
> example to troubleshoot execution plans, other than writing a named
> prepared statement, or manually subbing the parameters?

psql hasn't any way to do that.  You might consider pgbench as a
possible substitute though --- not only can it do PARSE/BIND/EXECUTE,
but you can insert appropriate parameter values via variables.

            regards, tom lane


В списке pgsql-general по дате отправления:

Предыдущее
От: chiru r
Дата:
Сообщение: Re: PgBackRest question?
Следующее
От: David Steele
Дата:
Сообщение: Re: PgBackRest question?