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 <pie...@hogranch.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 > >