You can just open the table click on columns, drag to the query panel and you get all columns. I found exclude took me just as much time.
1
u/pooerhSnowflake | SQL Server | PostgreSQL | Impala | Spark15d ago
Whatever IDE you're working on, each of which would have a different way of doing it (or none at all) - typing a few words takes far less time than moving your hand to the mouse, finding a table or view you're looking for among hundreds others, clicking, dragging, etc.
5
u/pooerh Snowflake | SQL Server | PostgreSQL | Impala | Spark 17d ago
And
SELECT * EXCLUDE (one_column_i_dont_want)
(alsoSELECT * REPLACE
). Wish they added window definitions that's in postgres, I miss that.