Re: how do I check if a temporary table exists?

Thus spake datactrl
> How do I check if a temporary table exists? Searching pg_tables with a
> temporary table name we chose always fails.

What do you mean?  You know that it exists because you just created it
and the create succeeded.  Can you describe a situation where you need
to know about a temp table and don't already know?

It can't go into the pg_tables table because then it would be visible
to other processes.  Are you perhaps misunderstanding temp tables?  You
cannot see them except from the process that created them.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.