Re: UPDATEABLE VIEWS ... Examples?

From: David Pradier <dpradier(at)apartia(dot)fr>
To: Jaime Casanova <systemguards(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: UPDATEABLE VIEWS ... Examples?
Date: 2005-06-20 07:27:55
Message-ID: 20050620072755.GC15942@apartia.fr
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

Thanks Jaime, it's perfectly clear now.

David

--
dpradier(at)apartia(dot)fr - tel: 01.46.47.21.33 - fax: 01.46.47.21.37

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Glaesemann 2005-06-20 07:37:57 Re: UPDATEABLE VIEWS ... Examples?
Previous Message Jaime Casanova 2005-06-20 07:24:39 Re: UPDATEABLE VIEWS ... Examples?