Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Temporary Views or tables



Hi all,

I'm trying to use temporary views in my application, before i proceed and go ahead for creating the temorary view i would like more abt it.
1) when is the temporary view automatically deleted. Is it after we close the connection or when the session ends....for.e.g  my website doesnt
  use a persistant connection to my postgres server and it queries and then disconnects from the db server. In one of such connections...if i create a temporary view
  will this temp view be visible to me after multiple disconnects and connects ????
2) Is the view approach faster then creating temporary tables??? (and the same question as abovew for temp. tables.)
3) If there are multiple users who connect to my website at the same time and create temporary views or tables with the same name would there be any overlapping or such???

--
Thanks,
Sumeet.


Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group