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

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

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