Re: Is a table temporary

From: "Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Is a table temporary
Date: 2005-09-15 21:58:48
Message-ID: F7638DABBEBB4A4CB70616DE2B19E6B825F70A@COENGEXCMB01.cable.comcast.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Thanks, that works great.

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

"Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)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

Browse pgsql-novice by date

  From Date Subject
Next Message Peter Cook 2005-09-16 04:54:00 Application access to postgreSQL
Previous Message Tom Lane 2005-09-15 20:20:45 Re: Is a table temporary