Re: UPDATEABLE VIEWS ... Examples?

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: David Pradier <dpradier(at)apartia(dot)fr>
Cc: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org
Subject: Re: UPDATEABLE VIEWS ... Examples?
Date: 2005-06-20 07:24:39
Message-ID: c2d9e70e050620002430cb0c38@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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 ;)

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Pradier 2005-06-20 07:27:55 Re: UPDATEABLE VIEWS ... Examples?
Previous Message David Pradier 2005-06-20 07:16:05 Re: UPDATEABLE VIEWS ... Examples?