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?
---(end of broadcast)---
TIP 8: explain analyze is your friend
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