Postgres Pro
Downloads
Home   >   mailing lists

Re: how to create materialized view in postgresql 8.3 - Mailing list pgsql-general

From Michael Paquier
Subject Re: how to create materialized view in postgresql 8.3
Date
Msg-id CAB7nPqQd1_peCELrqTxRhRL0gJxoJz4+Wf-AvvcTRPExZa81vg@mail.gmail.com
Whole thread Raw
In response to Re: how to create materialized view in postgresql 8.3  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-general
Tree view



On Mon, Apr 8, 2013 at 4:57 PM, Gavin Flower <GavinFlower@archidevsys.co.nz> 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

pgsql-general by date:

Previous
From: "Takashi Ohnishi"
Date:
Subject: Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master
Next
From: Vincent Veyron
Date:
Subject: Re: Hosting PG on AWS in 2013