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

So, lately I have been thinking about integrating explain.depesz.com with psql. Currently, you have to run explain, copy the output, switch to webbrowser, go to explain.depesz.coma> site, paste output, click submit. It's not that it's a lot of work, but ...

So, you just installed your PostgreSQL, and you have no idea how to use it - there is no icon in the menu of your OS, so how can you use it? Well, with the dreadful command line. Of course - ...

I use VIM. For more or less everything. Including writing blogposts. Usually, when I was working on blogpost about PostgreSQL, I would write an sql file, switch to another console with psql running, run \i, get output, and then copy/paste the ...

Recent release of new versions of PostgreSQL suggests that you do reindex of all indexes. But this will take a while, and since we don't actually have 'REINDEX CONCURRENTLY' command - it's a bit tricky. So, since I will be doing ...