"Loeke" <[EMAIL PROTECTED]> writes: > do views exist fysically a separate "table", or are they generated > on the fly whenever they are queried?
Views are implementing by rewriting queries into the appropriate query on the view's base tables. http://www.postgresql.org/docs/current/static/rules-views.html > if they exist fysically they could improve performance (..php, web), This is called a "materialized view". PostgreSQL doesn't support them yet, but most people think it would be a Good Thing to have. -Neil ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
