amazon-web-servicesamazon-redshift

Is there anyway to do SELECT * EXCEPT (col1, col2, ...) ... in RedShift?

In BigQuery I can write:

SELECT * EXCEPT (col1, col2, ...) ...

Is there an equivalent for RedShift? I don't think there is, but I wanted to see if anyone had any bright ideas.

Incidentally, I find this to be very useful in BigQuery when writing multiple subqueries, each flowing into the next. I can include/exclude columns at the relevant part of the query without having it break something later on, which is very useful when developing a complex query.

Solution

  • Not to my knowledge.

    The only EXCEPT is the normal SELECT functionality to subtract one relation from another.