Views vs Generated Columns

We are going to talk about SQL Views and Generated Columns in postgresql. Introduction Views Have you heard about views in SQL? Maybe! Since it has been here since approximatly forever. For those who don’t what a view is, here is a example : CREATE TABLE person ( p_id uuid primary key, p_firstname text, p_lastname text, p_whatever_you_need_to_know text, ); CREATE VIEW v_person AS SELECT p_firstname, p_lastname FROM person; So views are basically a SELECT....

April 23, 2020 · Rémi Desgrange