diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2022-07-05 07:21:40 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2022-07-05 07:23:32 +0200 |
| commit | 84ad713cf85aeffee5dd39f62d49a1b9e34632da (patch) | |
| tree | 2be3003c63b57e871f63534a024668480831314f /doc/src | |
| parent | eb64ceac7ec3422f2370b8824dce62ee8fe52dca (diff) | |
Add result_types column to pg_prepared_statements view
Containing the types of the columns returned by the prepared
statement.
Prompted by question from IRC user mlvzk.
Author: Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>
Discussion: https://www.postgresql.org/message-id/flat/871qwpo7te.fsf@wibble.ilmari.org
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 25b02c4e37e..ef7ae7e8fdc 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -11504,6 +11504,18 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx <row> <entry role="catalog_table_entry"><para role="column_definition"> + <structfield>result_types</structfield> <type>regtype[]</type> + </para> + <para> + The types of the columns returned by the prepared statement in the + form of an array of <type>regtype</type>. The OID corresponding + to an element of this array can be obtained by casting the + <type>regtype</type> value to <type>oid</type>. + </para></entry> + </row> + + <row> + <entry role="catalog_table_entry"><para role="column_definition"> <structfield>from_sql</structfield> <type>bool</type> </para> <para> |