If I create a view based on a table or tables, does that view get automatically updated when the original data is updated? Or is a view more of a snapshot of the data at the instance of its creation?
I've poked around the postgres.org documentation, but was not able to find a definitive answer. I suspect there may be something simple I am missing.
A view is a mask that is applied to a table / set of tables / set of databases in order to make retrieval easier. In many cases retrieval times can be decreased with the use of a view because the db engine (query engine) can analyze and predict better what indexes to use.
Also I know that in Oracle (not sure about Postgres) You can join tables in totally seperate databases (even if they are on different servers) with the use of views.
Bookmarks