Re: Indexing Views

From: frbn <frbn(at)efbs-seafrigo(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Indexing Views
Date: 2002-07-04 12:38:00
Message-ID: 3D2441A8.2060802@efbs-seafrigo.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

sid(at)questions(dot)com wrote:
> hi,
>
> I am storing intermediate results in a view and then using this view for
> further processing, is it possible to index views in Postgres, if so how?
> Any help will be much appreciated.

you can use a temporary table which can be indexed.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Angela Luyf 2002-07-04 13:33:11 two primairy key in one table ?
Previous Message Nils Höglund 2002-07-04 11:38:03 Re: Fwd: Re: Comparing PostgreSQL and Oracle stability