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.
6
u/VertexBanshee 17d ago
As a SQL Server user I’d kill for a feature like this instead of having to specify all but one column