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. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
