Re: temporary tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Sugrue, Sean" <Sean(dot)Sugrue(at)analog(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: temporary tables
Date: 2003-04-10 19:56:01
Message-ID: 6140.1050004561@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"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
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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Don Patou 2003-04-10 21:42:42 looking for a script to compare databases
Previous Message Sugrue, Sean 2003-04-10 19:18:30 temporary tables