Strong views on PostgreSQL VIEWs

2026-05-14

Views are just stored rewrite rules (macros) that get expanded at query time. They behave like tables for simple cases, but create hidden complexity through nested spirals, fragile dependencies on attribute numbers, painful schema changes, and limited writability, often leading to the classic advice: “use them, but don't treat them like tables.”