Temporary Views or tables - Mailing list pgsql-sql

From Sumeet
Subject Temporary Views or tables
Date
Msg-id 7539aebb0608280729g7094affkeac9594c828f56d2@mail.gmail.com
Whole thread Raw
List pgsql-sql
Hi all,<br /><br />I'm trying to use temporary views in my application, before i proceed and go ahead for creating the
temoraryview i would like more abt it.<br />1) when is the temporary view automatically deleted. Is it after we close
theconnection or when the session ends....for.e.g  my website doesnt <br />  use a persistant connection to my postgres
serverand it queries and then disconnects from the db server. In one of such connections...if i create a temporary
view<br/>  will this temp view be visible to me after multiple disconnects and connects ???? <br />2) Is the view
approachfaster then creating temporary tables??? (and the same question as abovew for temp. tables.)<br />3) If there
aremultiple users who connect to my website at the same time and create temporary views or tables with the same name
wouldthere be any overlapping or such??? <br /><br />-- <br />Thanks,<br />Sumeet.<br /> 

pgsql-sql by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Create Assertion -- Question from a newbie
Next
From: Michael Fuhr
Date:
Subject: Re: Trigger on Insert to Update only newly inserted fields?