| From: | Mike Christensen <mike(at)kitchenpc(dot)com> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: how to create materialized view in postgresql 8.3 |
| Date: | 2013-04-08 16:36:15 |
| Message-ID: | CABs1bs0SJMcOTg85i6LAUhadWxHFh1bHrrcg9FTChenD02-t4A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
This is the number one requested feature on Uservoice:
http://postgresql.uservoice.com/forums/21853-general/suggestions/247548-materialized-views
On Mon, Apr 8, 2013 at 9:27 AM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> 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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Boreham | 2013-04-08 17:00:02 | Re: Hosting PG on AWS in 2013 |
| Previous Message | John R Pierce | 2013-04-08 16:27:46 | Re: how to create materialized view in postgresql 8.3 |