Create line(qty int, price numeric, total numeric GENERATED ALWAYS AS (qty * price) STORED), insert (qty 3, price 10), and RETURN all columns.

Answer

CREATE TABLE line (qty int, price numeric, total numeric GENERATED ALWAYS AS (qty * price) STORED); INSERT INTO line (qty, price) VALUES (3, 10) RETURNING *;