Help Center > > Developer Guide> System Catalogs and System Views> System Views> PG_PREPARED_STATEMENTS

PG_PREPARED_STATEMENTS

Updated at: Jul 15, 2020 GMT+08:00

PG_PREPARED_STATEMENTS displays all prepared statements that are available in the current session.

Table 1 PG_PREPARED_STATEMENTS columns

Name

Type

Description

name

text

Identifier of the prepared statement

statement

text

Query string for creating this prepared statement For prepared statements created through SQL, this is the PREPARE statement submitted by the client. For prepared statements created through the frontend/backend protocol, this is the text of the prepared statement itself.

prepare_time

timestamp with time zone

Timestamp when the prepared statement is created

parameter_types

regtype[]

Expected parameter types for the prepared statement in the form of an array of regtype. The OID corresponding to an element of this array can be obtained by casting the regtype value to oid.

from_sql

Boolean

How a prepared statement was created

  • true: The prepared statement was created through the PREPARE statement.
  • false The statement was prepared through the frontend/backend protocol.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel