Many views are "auto updatable" in Postgres, meaning the db knows how to seamlessly pass updates down to the underlying relation. https://www.postgresql.org/doc

Many views are "auto updatable" in Postgres, meaning the db knows how to seamlessly pass updates down to the underlying relation. https://www.postgresql.org/docs/current/static/rules-views.html#RULES-VIEWS-UPDATE https://www.postgresql.org/docs/current/static/rules-views.h... For more updates to more complicated views (such as some joins), you can use a trigger as also described in the linked docs above.