From: Sumeet <asumeet@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Temporary Views or tables
Date: Mon, 28 Aug 2006 10:29:20 -0400
Message-ID: <7539aebb0608280729g7094affkeac9594c828f56d2@mail.gmail.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: asumeet@gmail.com
Subject: Re: Temporary Views or tables
In-Reply-To: <7539aebb0608280729g7094affkeac9594c828f56d2@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox