On Mon, Apr 8, 2013 at 4:57 PM, Gavin Flower <gavinflo...@archidevsys.co.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