Mimic parse bind execute in psql?

From: Jeremy Finzel <finzelj(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Mimic parse bind execute in psql?
Date: 2017-12-29 15:44:51
Message-ID: CAMa1XUjA4tXyYkrDjpm9S5epcgZCt_viTt4d57fYWYhe5WXwAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

It would be nice to take the commands just as in they appear in the log
files and execute them in psql as PARSE .... BIND ... EXECUTE. Perhaps I'm
missing something?

Thanks,
Jeremy

Responses

Browse pgsql-general by date

  From Date Subject
Next Message chiru r 2017-12-29 15:58:53 Re: PgBackRest question?
Previous Message mark 2017-12-29 14:05:08 Re: postgresql9.5 partition table