Is there a way to
SELECT all columns in a table, except specific ones? IT would be very convenient for selecting all the non-blob or non-geometric columns from a table.
SELECT * -the_geom FROM segments;
- I once heard that this functionality was deliberately excluded from the SQL standard because changing adding columns to the table will alter the query results. Is this true? Is the argument valid?
- Is there a workaround, especially in PostgreSQL?