Temporary Views or tables

Поиск
Список
Период
Сортировка
От Sumeet
Тема Temporary Views or tables
Дата
Msg-id 7539aebb0608280729g7094affkeac9594c828f56d2@mail.gmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Create Assertion -- Question from a newbie
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Trigger on Insert to Update only newly inserted fields?