Le 15/10/2021 à 20:51, Bruce Momjian a écrit : > Why is this not better addressed by creating a view on the original > table, even perhaps renaming the original table and create a view using > the old table name.
Because when you use the view for the select you can not use the "hidden" column in your query, for example in the WHERE or ORDER BY clause. Also if you have a hundred of tables, let's says with a ts_vector column that you want to unexpand, you will have to create a hundred of view. The other problem it for write in the view, it you have a complex modification involving other tables in the query you have to define rules. Handling a technical column through a view over the real table require lot of work, this feature will help a lot to save this time. -- Gilles Darold