Re: how to create materialized view in postgresql 8.3

[Michael Paquier <michael.paquier@xxxxxxxxx>]

On Mon, Apr 8, 2013 at 4:57 PM, Gavin Flower <GavinFlower@xxxxxxxxxxxxxxxxx> wrote:

On 08/04/13 18:58, Zahid Quadri wrote:

is it possible to created materialized view in postgresql 8.3 if yes please provide some sample.

8.3 is no longer supported

Zahid, I think that you have mistaken 8.3 and 9.3. Materialized views have just been implemented and will be available in postgres 9.3 whose release is planned this year.
For your example. documentation is your friend:
http://www.postgresql.org/docs/devel/static/sql-creatematerializedview.html

--
Michael