Re: Mimic parse bind execute in psql? - Mailing list pgsql-general

From Tom Lane
Subject Re: Mimic parse bind execute in psql?
Date
Msg-id 21731.1514564465@sss.pgh.pa.us
Whole thread Raw
In response to Mimic parse bind execute in psql?  (Jeremy Finzel <finzelj@gmail.com>)
List 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 by date:

Previous
From: chiru r
Date:
Subject: Re: PgBackRest question?
Next
From: David Steele
Date:
Subject: Re: PgBackRest question?