Radim Marek: Strong views on PostgreSQL VIEWs

https://postgr.es/p/9iP

#postgresql

Strong views on PostgreSQL VIEWs

Views are PostgreSQL's cleanest abstraction and its most rigid one. How rewrite rules, attribute numbers, and the dependency catalog conspire to make every column change a teardown, and what is missing in core that would fix it.

boringSQL | Supercharge your SQL & PostgreSQL powers