On 4th of April, Tom Lane committed patch:
Add a \gexec command to psql for evaluation of computed queries.
\gexec executes the just-entered query, like \g, but instead of printing
the results it takes each field as a SQL command to send to the server.
Computing a series of queries to be executed is a fairly common thing,
but up to now you always had to resort to kluges like writing the queries
to a file and then inputting the file. Now it can be done with no
The implementation is fairly straightforward except for its interaction
with FETCH_COUNT. ExecQueryUsingCursor isn't capable of being called
recursively, and even if it were, its need to create a transaction
block interferes unpleasantly with the desired behavior of \gexec after
a failure of a generated query (i.e., that it can continue). Therefore,
disable use of ExecQueryUsingCursor when doing the master \gexec query.
We can still apply it to individual generated queries, however, and there
might be some value in doing so.
While testing this feature's interaction with single-step mode, I (tgl) was
led to conclude that SendQuery needs to recognize SIGINT (cancel_pressed)
as a negative response to the single-step prompt. Perhaps that's a
back-patchable bug fix, but for now I just included it here.
Corey Huinker, reviewed by Jim Nasby, Daniel Vérité, and myself
Continue reading Waiting for 9.6 – Add a \gexec command to psql for evaluation of computed queries.
On 8th of December, Robert Haas committed patch:
psql: Support multiple -c and -f options, and allow mixing them.
To support this, we must reconcile some historical anomalies in the
behavior of -c. In particular, as a backward-incompatibility, -c no
longer implies --no-psqlrc.
Pavel Stehule (code) and Catalin Iacob (documentation). Review by
Michael Paquier and myself. Proposed behavior per Tom Lane.
Continue reading Waiting for 9.6 – psql: Support multiple -c and -f options, and allow mixing them.
On 7th of July, Andres Freund committed patch:
Add psql PROMPT variable showing the pid of the connected to backend.
The substitution for the pid is %p.
Author: Julien Rouhaud
Discussion: <a href="http://git.postgresql.org/gitweb/?p=postgresql.git;a=object;h=116262CF971C844FB6E793F8809B51C6E99D48">116262CF971C844FB6E793F8809B51C6E99D48</a>@BPXM02GP.gisp.nec.co.jp
Continue reading Waiting for 9.6 – Add psql PROMPT variable showing the pid of the connected to backend.
On 3rd of July, Tom Lane committed patch:
Add psql \ev and \sv commands for editing and showing view definitions.
These are basically just like the \ef and \sf commands for functions.
Petr Korobeinikov, reviewed by Jeevan Chalke, some changes by me
Continue reading Waiting for 9.6 – Add psql \ev and \sv commands for editing and showing view definitions.
On 31st of March, Bruce Momjian committed patch:
psql: add asciidoc output format
Patch by Szymon Guz, adjustments by me
Testing by Michael Paquier, Pavel Stehule
Continue reading Waiting for 9.5 – psql: add asciidoc output format
I was working today on some updates to client database. While doing it, I figured it would be simpler if I saw all “codenames" and ids of rows from dictionary table – not so big. But it was bigger than my screen – I have only 90 lines of text on screen, and there were ~ 200 rows of data in the table. So I started thinking – how to show this (codename, id) into more than one column, in psql.
Continue reading Returning data in multiple columns
On 2nd of September, Andres Freund committed patch:
Add psql PROMPT variable showing which line of a statement is being edited.
The new %l substitution shows the line number inside a (potentially
multi-line) statement starting from one.
Author: Sawada Masahiko, heavily editorialized by me.
Reviewed-By: Jeevan Chalke, Alvaro Herrera
Continue reading Waiting for 9.5 – Add psql PROMPT variable showing which line of a statement is being edited.
On 14th of July, Alvaro Herrera committed patch:
psql: Show tablespace size in \db+
Fabrízio de Royes Mello
Continue reading Waiting for 9.5 – psql: Show tablespace size in \db+
On 28th of April, Greg Stark committed patch:
Add support for wrapping to psql's "extended" mode. This makes it very
feasible to display tables that have both many columns and some large
data in some columns (such as pg_stats).
Emre Hasegeli with review and rewriting from Sergey Muraviov and
reviewed by Greg Stark
Continue reading Waiting for 9.4 – Add support for wrapping to psql's “extended" mode.
On 19th of November, Fujii Masao committed patch:
Add tab completion for \pset in psql.
Pavel Stehule, reviewed by Ian Lawrence Barwick
Continue reading Waiting for 9.4 – Add tab completion for \pset in psql.