Postgres Pro
Downloads
Home   >   mailing lists

Thread: Indexed views.

Indexed views.

From
prasanna s
Date:
Does postgres support indexed views/materialised views that some of the other databases support?

Thanks
Prasanna S

Re: Indexed views.

From
Christopher Kings-Lynne
Date:
No, unless you use some custom triggers.

prasanna s wrote:
> Does postgres support indexed views/materialised views that some of the
> other databases support?
>
> Thanks
> Prasanna S

Re: Indexed views.

From
Laszlo Hornyak
Date:
prasanna s wrote:

> Does postgres support indexed views/materialised views that some of
> the other databases support?
>
> Thanks
> Prasanna S

Hi!

It is not supported, but perhaps this will help you:
http://www.varlena.com/varlena/GeneralBits/Tidbits/matviews.html