[postgresql] Computed / calculated / virtual / derived columns in PostgreSQL

One way to do this is with a trigger!

CREATE TABLE computed(
    one SERIAL,
    two INT NOT NULL
);

CREATE OR REPLACE FUNCTION computed_two_trg()
RETURNS trigger
LANGUAGE plpgsql
SECURITY DEFINER
AS $BODY$
BEGIN
    NEW.two = NEW.one * 2;

    RETURN NEW;
END
$BODY$;

CREATE TRIGGER computed_500
BEFORE INSERT OR UPDATE
ON computed
FOR EACH ROW
EXECUTE PROCEDURE computed_two_trg();

The trigger is fired before the row is updated or inserted. It changes the field that we want to compute of NEW record and then it returns that record.

Examples related to postgresql

Subtracting 1 day from a timestamp date pgadmin4 : postgresql application server could not be contacted. Psql could not connect to server: No such file or directory, 5432 error? How to persist data in a dockerized postgres database using volumes input file appears to be a text format dump. Please use psql Postgres: check if array field contains value? Add timestamp column with default NOW() for new rows only Can't connect to Postgresql on port 5432 How to insert current datetime in postgresql insert query Connecting to Postgresql in a docker container from outside

Examples related to calculated-columns

The condition has length > 1 and only the first element will be used pandas dataframe create new columns and fill with calculated values from same df getting "No column was specified for column 2 of 'd'" in sql server cte? Computed / calculated / virtual / derived columns in PostgreSQL SQL Server String Concatenation with Null

Examples related to sql-view

Working with SQL views in Entity Framework Core Create view with primary key? Computed / calculated / virtual / derived columns in PostgreSQL SQL Views - no variables? Entity Framework and SQL Server View

Examples related to materialized-views

How to refresh materialized view in oracle Computed / calculated / virtual / derived columns in PostgreSQL What is the difference between Views and Materialized Views in Oracle?

Examples related to generated-columns

Computed / calculated / virtual / derived columns in PostgreSQL