AWS Redshift Select all except some columns

950 views Asked by At

I've got a problem where I want to select all from a table/view except some columns. Is there any way of achieving this without creating a procedure?

1

There are 1 answers

0
dfundako On

No. BigQuery and I think Snowflake might support it, but Redshift doesn't support SELECT * EXCEPT syntax.