On 20th of July, Robert Haas committed (and later committed change to it) patch which adds another \* command to psql: Log Message: ----------- Add \conninfo command to psql, to show current connection info. David Christensen. Reviewed by Steve Singer. Some further changes ...

On 22nd of November Tom Lane committed patch by Roger Leigh which fixes my pet peeve: Log Message: ----------- Improve psql's tabular display of wrapped-around data by inserting markers in the formerly-always-blank columns just to left and right of the data. Different marking is used ...

Yesterday Peter Eisentraut committed a patch, written by Damien Clochard, that modifies \d output in psql: Have \d show child tables that inherit from the specified parent   As per discussion, \d shows only the number of child tables, because that could be hundreds, ...

Let's say you imported some data, but it contains duplicates. You will have to handle them in some way, but to make sensible choice on how to handle it, you need more information. So, let's start. We have table: # \d users ...

On 6th of January Bruce Momjian committed patch by Greg Sabino Mulane, which fixes one of a very long standing annoyances in PostgreSQL - removes system objects from \dX commands in psql.

September 6th, 2008 by depesz | Tags: , , , , | No comments »

Today, Tom Lane committed patch, written by Abhijit Menon-Sen, which adds interesting feature to psql. Namely - it simplifies changing definition of functions.

Gregory Stark wrote, and Bruce Momjian committed (on 14th of July) patch which shows storage type in psql.

On 15th of July, Bruce Momjian commited patch written by Dickson S. Guedes, which: Have psql \d show the value of sequence columns.

CONTEXT messages are quite informative, but when you don't need them, they can be real pain in the eyes: psql:trees.sql:68: NOTICE: Adding tree structures to table public.testit. CONTEXT: SQL function "add_tree_structure" statement 1 psql:trees.sql:68: NOTICE: Tree table will be public.testit_tree. CONTEXT: ...

Yes, finally! David Fetter wrote, and Heikki Linnakangas committed patch which adds on/off arguments to \timing: