Databases · Middle · Question 69 of 75

What is a generated column?

ALTER TABLE users
  ADD COLUMN email_lower text GENERATED ALWAYS AS (lower(email)) STORED;

1A column created by an ORM
✓Correct answer: A column computed by the database from other columns of the same row, kept up to date automatically
3A column filled with random values

Explanation

It can be indexed and can't get out of sync. Since PostgreSQL 18 generated columns can also be virtual (computed on read).

Further reading

Test yourself

Take the Databases · Middle quiz: questions and options are shuffled, and you get a review of your mistakes at the end.