re: Explain Postgresql Views Like I'm Five VIEW POST

VIEW PARENT COMMENT VIEW FULL DISCUSSION

Hey Ben,

SQL views aren't just stored queries, it's a virtual table. You can make joins and select specific columns, granting permissions to different database users to it, instead of granting permission to every table. Views are also indexed, when talking about materialized views.

So by using SQL views you've got: security, performance and simplicity. Also, not every system is backed by a modern application layer.

code of conduct - report abuse