| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
| Cc: | Zahid Quadri <zahid(dot)quadri(at)cloverinfotech(dot)com>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: how to create materialized view in postgresql 8.3 |
| Date: | 2013-04-08 08:23:10 |
| Message-ID: | CAB7nPqQd1_peCELrqTxRhRL0gJxoJz4+Wf-AvvcTRPExZa81vg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Apr 8, 2013 at 4:57 PM, Gavin Flower
<GavinFlower(at)archidevsys(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vincent Veyron | 2013-04-08 09:15:20 | Re: Hosting PG on AWS in 2013 |
| Previous Message | Takashi Ohnishi | 2013-04-08 07:59:33 | Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master |