"Sugrue, Sean" <Sean(dot)Sugrue(at)analog(dot)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
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
In response to
pgsql-novice by date
|Next:||From: Don Patou||Date: 2003-04-10 21:42:42|
|Subject: looking for a script to compare databases|
|Previous:||From: Sugrue, Sean||Date: 2003-04-10 19:18:30|
|Subject: temporary tables|