temporary views

jasiek <jasiek@lamer.pl>

From: Tomasz Myrta <jasiek@lamer.pl>
To: pgsql-sql@postgresql.org
Date: 2001-10-04T15:51:48Z
Lists: pgsql-sql
Hi
I have simple question: How to create view on a temporary table?
I need this, because pl/pgsql function returns data via temporary table.

View created on a temporary table is useful only to the end of session. 
Next time i create the same temp table i get 
"Table xxx with oid xxx doesn't exist"

Tomek