"Loeke" <LoekeDoeLoekeDoe(at)dontlikespam(dot)hotmail(dot)com> 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