Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group