Horton

Re: temporary views

Bruce Momjian <pgman@candle.pha.pa.us>

View thread View on postgr.es
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tomasz Myrta <jasiek@lamer.pl>
Cc: pgsql-sql@postgresql.org
Date: 2001-10-04T17:43:22Z
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"

Just name your temporary table the same name in every session.  Why
bother with a view. 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026