"Sugrue, Sean" <Sean.Sugrue@analog.com> writes:
> Is there anyway that postgresql will tell you if there is a temporary table without
> knowing the table name?
Please define what you are trying to do more exactly. Do you want to
know if any current session has temporary tables? If your own session
has at least one temporary table? If your own session has created a
particular temp table (and if so, what's that about "not knowing the
table name")?
It also matters which PG version you want to do this on -- the catalog
representation of temp tables has changed in 7.3.
regards, tom lane