Re: Temp table exists test??

Michael Guerin <guerin(at)rentec(dot)com> writes:
> I'm trying to detect the existence of a temp table in a function for
> that connection.

Perhaps something like

select * from pg_class where relname = 'foo' and pg_table_is_visible(oid);

However this will potentially trigger on non-temp tables, if you have
any of matching names that are in your search path. Dunno if that's a
problem for your application.

Another way is to look at current_schemas(), though you would need to
check whether the first entry is a temp schema or not (it isn't until
you've created at least one temp table):

regression=# select current_schemas(true);
current_schemas
---------------------
{pg_catalog,public}
(1 row)

regression=# create temp table foo(f1 int);
CREATE TABLE
regression=# select current_schemas(true);
current_schemas
-------------------------------
{pg_temp_1,pg_catalog,public}
(1 row)

regression=# select (current_schemas(true))[1];
current_schemas
-----------------
pg_temp_1
(1 row)

regression=#

regards, tom lane