Re: Is a table temporary - Mailing list pgsql-novice

Thanks, that works great.

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, September 15, 2005 2:21 PM
To: Walker, Jed S
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Is a table temporary

"Walker, Jed S" <Jed_Walker@cable.comcast.com> writes:
> Is there a way to determine if a table is temporary.

Temporary tables live in schemas named pg_temp_NNN.

            regards, tom lane