Re: views?

"Loeke" <LoekeDoeLoekeDoe@dontlikespam.hotmail.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