News for hackers. Stuff that matters.
Re:Selecting All Columns Except One in PostgreSQL by teej on Saturday May 19, 2018 @10:43AM (#17108073)

    CREATE TABLE safe_users AS
    SELECT *
           EXCEPT users.pii
      FROM users
    ;
Lots and lots of uses for this feature. I often wish I had it in Redshift.
Re:Selecting All Columns Except One in PostgreSQL by jlgaddis on Saturday May 19, 2018 @05:21PM (#17109800)
I suppose it could be useful for keeping your "breach notification team" busy, after somebody (for whatever reason) adds a "users.hiv_positive" (boolean) column or some such and that column ends up being included somewhere you didn't intend it to be.

"Root cause analysis: The {database administrators|programmers} were too lazy to explicitly define the column names they wanted, resulting in the unintended disclosure of HIV positive status of $bignum individuals."