Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Is a table temporary
Date
Msg-id 16228.1126815645@sss.pgh.pa.us
Whole thread Raw
In response to Is a table temporary  ("Walker, Jed S" <Jed_Walker@cable.comcast.com>)
List pgsql-novice
Tree view 
"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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: problem with pg_dump and subsequent restoration.
Next
From: "Walker, Jed S"
Date:
Subject: Re: Is a table temporary