> This is maybe a newbie question, but what is the difference with a > materialized view ? >
An updateable view is one you can insert, delete or update rows. A materialized view is one that is pre-executed... i mean, that the data is stored in a file for fast execution of the view -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq