On Thu, 14 Oct 2021 at 07:17, Gilles Darold <gilles@migops.com> wrote:
The user defined columns are always visible in the PostgreSQL. If user wants to hide some column(s) from a SELECT * returned values then the hidden columns feature is useful. Hidden column can always be used and returned by explicitly referring it in the query.
It seems to me we've gone in the reverse direction recently. It used to be that the oid columns of the system tables were hidden (hardcoded, as far as I know), but as of Postgres 12 I believe there are no more hidden columns: SELECT * from a table always gives all the columns.
I think a "select all columns except …" would be more useful; or another approach would be to use a display tool that defaults to displaying only a portion of large fields.