0

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?

John Rotenstein
  • 241,921
  • 22
  • 380
  • 470
AIViz
  • 82
  • 9

1 Answers1

3

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

dfundako
  • 8,022
  • 3
  • 18
  • 34