| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | andy(dot)hardin(at)gmail(dot)com |
| Subject: | Virtual Generated Columns |
| Date: | 2025-12-05 13:57:40 |
| Message-ID: | 176494306051.2921398.8686936183868575892@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/17/ddl-generated-columns.html
Description:
The documentation for generated columns in PostgreSQL versions prior to 18
mention "virtual" columns, but as far as I can tell, this is not available
prior to 18.
In v17, this is just in the first paragraph.
> A generated column is a special column that is always computed from other
columns. Thus, it is for columns what a view is for tables. There are two
kinds of generated columns: stored and virtual. A stored generated column is
computed when it is written (inserted or updated) and occupies storage as if
it were a normal column. A virtual generated column occupies no storage and
is computed when it is read. Thus, a virtual generated column is similar to
a view and a stored generated column is similar to a materialized view
(except that it is always updated automatically). PostgreSQL currently
implements only stored generated columns.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bob Kline | 2025-12-06 14:07:17 | Inclusion of json in list of standard data types |
| Previous Message | Laurenz Albe | 2025-12-04 18:11:44 | Re: Documentation clarification request: pg_dumpall and Large Objects |