Re: [GENERAL] Detecting Temporary Tables

2004-12-10 Thread 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:

[GENERAL] Detecting Temporary Tables

2004-12-06 Thread Jamie Deppeler
Is it possible to detect the instance of a Temporary through a function? ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Detecting Temporary Tables

2004-12-06 Thread Michael Fuhr
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