Difference between materialized view and table

From: sayali k <sayali_s_kulkarni(at)yahoo(dot)co(dot)in>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Difference between materialized view and table
Date: 2007-10-14 15:33:33
Message-ID: 40649.95464.qm@web7607.mail.in.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello all,
As of now, PGSQL does not support materialized views. Just wanted to confirm the difference between the materialized view and table. Is there some operation which can be performed only on a table and not on a materialized view or vice-versa?

Please let me know.
Thanks in advance,

Best regards,
Sayali

== ~~~ == ~~~ == ~~~ == ~~~ == ~~~ == ~~~ == ~~~ == ~~~ ==
Happiness is nothing more than a good health and a bad memory
== ~~~ == ~~~ == ~~~ == ~~~ == ~~~ == ~~~ == ~~~ == ~~~ ==


---------------------------------
For ideas on reducing your carbon footprint visit Yahoo! For Good this month.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-10-14 15:41:31 Back-patch support for python 2.5?
Previous Message Trevor Talbot 2007-10-14 14:02:40 Re: Including Snapshot Info with Indexes