Re: [GENERAL] Detecting Temporary Tables

[Jamie Deppeler]

What i want to be able to do is create a tempory table and when i need a 
value stored in the table  i want to check that the table has been 
created if it has not do a create temp table .... or just do an update.

Michael Fuhr wrote:
On Tue, Dec 07, 2004 at 09:22:51AM +1100, Jamie Deppeler wrote:

Is it possible to detect the instance of a Temporary through a function?

What are you trying to do?
Temporary tables are stored in the pg_temp_NNN schema (e.g.,
pg_temp_1).  See the "System Catalogs" chapter in the PostgreSQL
documentation for information on finding a table's schema.  If
you're using 7.4 or later then see also the "Information Schema"
chapter -- one of its views has two fields that should be helpful.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]