Re: how to create materialized view in postgresql 8.3

p { margin: 0; }

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