Wiki / psql Commands / Query execution
\parse
Creates a prepared statement from the current query buffer, based on the name of a destination prepared-statement object. An empty string denotes the unnamed prepared statement.
Reading PostgreSQL 18.6.
Description
Creates a prepared statement from the current query buffer, based on the name of a destination prepared-statement object. An empty string denotes the unnamed prepared statement.
- Client
- psql 18.6
- Case-sensitive spelling
- \parse
Usage
\parse statement_nameSpellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \parse | None listed in this signature |
Manual definition
\parsestatement_name-
Creates a prepared statement from the current query buffer, based on the name of a destination prepared-statement object. An empty string denotes the unnamed prepared statement.
Example:
SELECT $1 \parse stmt1
This command causes the extended query protocol to be used, unlike normal psql operation, which uses the simple query protocol. A Parse (F) message will be issued by this command so it can be useful to test the extended query protocol from psql. This command affects only the next query executed; all subsequent queries will use the simple query protocol by default.
Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
- Source fingerprint
ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8
Compare versions
PostgreSQL 17 → 18: added.
--- PostgreSQL 17
+++ PostgreSQL 18
@@ -1 +1,8 @@
-Not recorded in this version
+{
+ "definition": "Creates a prepared statement from the current query buffer, based on the name of a destination prepared-statement object. An empty string denotes the unnamed prepared statement. Example: SELECT $1 \\parse stmt1 This command causes the extended query protocol to be used, unlike normal psql operation, which uses the simple query protocol. A Parse (F) message will be issued by this command so it can be useful to test the extended query protocol from psql . This command affects only the next query executed; all subsequent queries will use the simple query protocol by default.",
+ "modifiers": [],
+ "signature": "\\parse statement_name",
+ "spellings": [
+ "\\parse"
+ ]
+}Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.
Related entries
Export JSON · Back to psql Commands · Recorded in PostgreSQL 18 through 20; the first sample is not necessarily its introduction.