Re: how to create materialized view in postgresql 8.3

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: how to create materialized view in postgresql 8.3
Date: 2013-04-08 16:27:46
Message-ID: 5162F002.30901@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 4/7/2013 11:58 PM, Zahid Quadri wrote:
>
> is it possible to created materialized view in postgresql 8.3 if yes
> please provide some sample.
>

in older versions, the best you could do was to create a table and
populate it with your 'view', then drop it when you're done (or truncate
and repopulate it to update the 'view').

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Christensen 2013-04-08 16:36:15 Re: how to create materialized view in postgresql 8.3
Previous Message Ben Chobot 2013-04-08 16:05:35 Re: Hosting PG on AWS in 2013