Re: UPDATEABLE VIEWS ... Examples? - Mailing list pgsql-sql

From Jaime Casanova
Subject Re: UPDATEABLE VIEWS ... Examples?
Date
Msg-id c2d9e70e050620002430cb0c38@mail.gmail.com
Whole thread Raw
In response to Re: UPDATEABLE VIEWS ... Examples?  (David Pradier <dpradier@apartia.fr>)
Responses Re: UPDATEABLE VIEWS ... Examples?  (David Pradier <dpradier@apartia.fr>)
Re: UPDATEABLE VIEWS ... Examples?  (Din Adrian <adrian.din@easynet.ro>)
List 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 ;)


pgsql-sql by date:

Previous
From: David Pradier
Date:
Subject: Re: UPDATEABLE VIEWS ... Examples?
Next
From: David Pradier
Date:
Subject: Re: UPDATEABLE VIEWS ... Examples?