Community

How to SELECT ALL EXCEPT some columns in a table

(Leo Hsu and Regina Obe) People have asked us on several occasions if there is such a construct SELECT * EXCEPT(…list) FROM sometable. Sadly we do not think such a thing exists in the ANSI SQL Specs nor in PostgreSQL.

Read More - Register for Free Membership