Virtual Generated Columns
| От | PG Doc comments form |
|---|---|
| Тема | Virtual Generated Columns |
| Дата | |
| Msg-id | 176494306051.2921398.8686936183868575892@wrigleys.postgresql.org обсуждение исходный текст |
| Ответы |
Re: Virtual Generated Columns
|
| Список | 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.
В списке pgsql-docs по дате отправления: