Peter J. Holzer wrote: > > My use case for such a feature are tables which contain one column (or a > > small number of columns) which you usually don't want to select: A bytea > > column or a very wide text column. In a program I don't mind (in fact I > > prefer) listing all the columns explicitely, but exploring a database > > interactively with psql typing lots of column names is tedious > > (especially since autocomplete doesn't work here). > > Forgot to add: I think that the syntax would have to be more explicit. > It's too easy to mix up > SELECT * - b.a_id FROM ... > and > SELECT *, - b.a_id FROM ... > > Maybe > SELECT * EXCEPT b.a_id FROM ... The solution to this by the SQL standard might be that it can be done with a Polymorphic Table Function, introduced in SQL:2016. https://webstore.iec.ch/preview/info_isoiec19075-7%7Bed1.0%7Den.pdf A practical example with the Oracle implementation can be seen here: https://blogs.oracle.com/sql/post/select-star-except-queries-in-oracle-database Excluding all columns of a given type from a relation is also possible, with both the relation and the type as parameters of the PTF. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: https://www.manitou-mail.org Twitter: @DanielVerite
