"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.


> 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.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to