Home Explore Blog CI



postgresql

23th chunk of `doc/src/sgml/release-18.sgml`
34e734a7995ebb6fbe73a1b9202f3e4a9c49605c0e1cac4e0000000100000fa2

<ulink url="&commit_baseurl;e87c14b19">&sect;</ulink>
<ulink url="&commit_baseurl;7adec2d5f">&sect;</ulink>
</para>
</listitem>

<!--
Author: Daniel Gustafsson <dgustafsson@postgresql.org>
2025-04-03 [2da74d8d6] libpq: Add support for dumping SSL key material to file
-->

<listitem>
<para>
Add libpq connection parameter sslkeylogfile which dumps out SSL key material (Abhishek Chanda, Daniel Gustafsson)
<ulink url="&commit_baseurl;2da74d8d6">&sect;</ulink>
</para>

<para>
This is useful for debugging.
</para>
</listitem>

<!--
Author: Thomas Munro <tmunro@postgresql.org>
2025-03-25 [3c86223c9] libpq: Deprecate pg_int64.
-->

<listitem>
<para>
Modify some libpq function signatures to use int64_t (Thomas Munro)
<ulink url="&commit_baseurl;3c86223c9">&sect;</ulink>
</para>

<para>
These previously used pg_int64, which is now deprecated.
</para>
</listitem>

    </itemizedlist>

   </sect3>

   <sect3 id="release-18-psql">
     <title><xref linkend="app-psql"/></title>

     <itemizedlist>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2024-08-22 [d55322b0d] psql: Add more meta-commands able to use the extended pr
-->

<listitem>
<para>
Allow psql to parse, bind, and close named prepared statements (Anthonin Bonnefoy, Michael Paquier)
<ulink url="&commit_baseurl;d55322b0d">&sect;</ulink>
</para>

<para>
This is accomplished with new commands \parse, \bind_named, and \close.
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2025-02-21 [41625ab8e] psql: Add support for pipelines
Author: Michael Paquier <michael@paquier.xyz>
2025-03-18 [17caf6644] psql: Add \sendpipeline to send query buffers while in a
Author: Michael Paquier <michael@paquier.xyz>
2025-03-19 [2cce0fe44] psql: Allow queries terminated by semicolons while in pi
-->

<listitem>
<para>
Add psql backslash commands to allowing issuance of pipeline queries (Anthonin Bonnefoy)
<ulink url="&commit_baseurl;41625ab8e">&sect;</ulink>
<ulink url="&commit_baseurl;17caf6644">&sect;</ulink>
<ulink url="&commit_baseurl;2cce0fe44">&sect;</ulink>
</para>

<para>
The new commands are \startpipeline, \syncpipeline, \sendpipeline, \endpipeline, \flushrequest, \flush, and \getresults.
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2025-02-25 [3ce357584] psql: Add pipeline status to prompt and some state varia
-->

<listitem>
<para>
Allow adding pipeline status to the psql prompt and add related state variables (Anthonin Bonnefoy)
<ulink url="&commit_baseurl;3ce357584">&sect;</ulink>
</para>

<para>
The new prompt character is "%P" and the new psql variables are PIPELINE_SYNC_COUNT, PIPELINE_COMMAND_COUNT, and PIPELINE_RESULT_COUNT.
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2024-12-18 [477728b5d] psql: Add more information about service name
-->

<listitem>
<para>
Allow adding the connection service name to the psql prompt or access it via psql variable (Michael Banck)
<ulink url="&commit_baseurl;477728b5d">&sect;</ulink>
</para>
</listitem>

<!--
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
2025-01-14 [00f4c2959] psql: Add option to use expanded mode to all list comman
-->

<listitem>
<para>
Add psql option to use expanded mode on all list commands (Dean Rasheed)
<ulink url="&commit_baseurl;00f4c2959">&sect;</ulink>
</para>

<para>
Adding 'x' enables this.
</para>
</listitem>

<!--
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
2025-02-22 [bba2fbc62] Change \conninfo to use tabular format
-->

<listitem>
<para>
Change psql's \conninfo to use tabular format and include more information (Álvaro Herrera, Maiquel Grassi, Hunaid Sohail)
<ulink url="&commit_baseurl;bba2fbc62">&sect;</ulink>
</para>
</listitem>

<!--
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
2025-01-14 [2355e5111] psql: Add leakproof indicator to \df+, \do+, \dAo+, and
-->

<listitem>
<para>
Add function's leakproof indicator to psql's \df+, \do+, \dAo+, and \dC+ outputs (Yugo Nagata)
<ulink url="&commit_baseurl;2355e5111">&sect;</ulink>

Title: PostgreSQL 18: psql Enhancements
Summary
This section details improvements in psql for PostgreSQL 18. Key updates include allowing psql to parse, bind, and close named prepared statements using new commands like \parse, \bind_named, and \close. It also introduces backslash commands for issuing pipeline queries, such as \startpipeline, \syncpipeline, and \endpipeline. Further enhancements involve adding pipeline status to the psql prompt, allowing connection service names to be added to the prompt or accessed via a variable, providing an option to use expanded mode on all list commands, changing \conninfo to a tabular format with more information, and including a function's leakproof indicator in various psql outputs like \df+.