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

February 4th, 2015 by depesz | Tags: , , , | 5 comments »

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 ...

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: ...

On 14th of July, Alvaro Herrera committed patch: psql: Show tablespace size in \db+ Fabrízio de Royes Mello

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 ...

On 19th of November, Fujii Masao committed patch: Add tab completion for \pset in psql. Pavel Stehule, reviewed by Ian Lawrence Barwick

On 3rd of October, Robert Haas committed patch: psql: Make \pset without arguments show all settings. Gilles Darold, reviewed by Pavel Stehule

On 4th of April, Tom Lane committed patch: Add \watch [SEC] command to psql. This allows convenient re-execution of commands. Will Leinweber, reviewed by Peter Eisentraut, Daniel Farina, and Tom Lane

One of the questions that gets asked quite a lot, is: how can you use variables in your queries? Other databases have them, does PostgreSQL? Actually the answer is "no". But, it is actually very easy to work around, and what's ...

On 2nd of February, Tom Lane committed patch: Create a psql command \gset to store query results into psql variables. This eases manipulation of query results in psql scripts. Pavel Stehule, reviewed by Piyush Newe, Shigeru Hanada, and Tom Lane