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.
Stupid tricks – hiding value of column in select *
One of the most common questions is “how do I get select * from table, but without one of the column".
Short answer is of course – name your columns, instead of using *. Or use a view.
But I decided to take a look at the problem.
Continue reading Stupid tricks – hiding value of column in select *
Waiting for 8.4 – column level privileges.
On 22nd of January, Tom Lane committed patch by Stephen Frost, which adds column level privileges:
Log Message: ----------- Support column-level privileges, as required by SQL standard. Stephen Frost, with help from KaiGai Kohei and others