Virtual Generated Columns — Zero-Storage Computed Attributes

PostgreSQL has had stored generated columns since version 12 — they persist the computed value to disk. PostgreSQL 18 adds virtual generated columns that compute the value at query time with zero storage cost.

Purchase this course to unlock the full lesson.

Sign up