Views in PostgreSQL are implemented using the rule system. A view is basically an empty table (having no actual storage) with an ON SELECT DO INSTEAD rule. Conventionally, that rule is named _RETURN. So a view like CREATE VIEW myview AS SELECT * FROM mytab; is very nearly the same thing as CREATE TABLE myview (same column list as mytab); CREATE RULE "_RETURN" AS ON SELECT TO myview DO INSTEAD SELECT * FROM mytab; although you can't actually write that, because tables are not allowed to have ON SELECT rules.
If you want to change selection, open document below and click on "Move attachment"
pdf
owner:
choralbari - (no access) - postgresql-16-A4.pdf, p1278
Summary
| status | not read | | reprioritisations | |
|---|
| last reprioritisation on | | | suggested re-reading day | |
|---|
| started reading on | | | finished reading on | |
|---|
Details