This is the number one requested feature on Uservoice:
On Mon, Apr 8, 2013 at 9:27 AM, John R Pierce <pierce@xxxxxxxxxxxx> 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
