April 19th, 2010 by depesz | Tags: column, columns, hide, plpgsql, postgresql, stupid | 13 comments »
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 ...
January 31st, 2009 by depesz | Tags: columns, grant, pg84, postgresql, privileges, revoke | 4 comments »
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
