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 по дате отправления: