From: | Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Detecting Temporary Tables |
Date: | 2004-12-07 22:40:38 |
Message-ID: | 41B63166.60809@doitonce.net.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Smith | 2004-12-07 22:42:51 | Re: postgresql and javascript |
Previous Message | Joachim Zobel | 2004-12-07 22:33:41 | Reusable database design |