Skip site navigation (1)
Skip section navigation (2)
Hi all. Is there a way to determine the existence of a TEMP TABLE? I need to check i it exists before I create it. Doing simple check on pg_class or pg_tables is
not enough because there may be other such tables created in other sessions. Or maybe anyone knows the identification (apart from 'others') of error to trap it with EXCEPTION clause?
Peripheral Links
Header And Logo
|
Site Navigation
temp table existence
- From: "Marcin Krawczyk" <jankes(dot)mk(at)gmail(dot)com>
- To: pgsql-sql(at)postgresql(dot)org
- Subject: temp table existence
- Date: Sat, 29 Dec 2007 20:16:33 +0100
Hi all. Is there a way to determine the existence of a TEMP TABLE? I need to check i it exists before I create it. Doing simple check on pg_class or pg_tables is
not enough because there may be other such tables created in other sessions. Or maybe anyone knows the identification (apart from 'others') of error to trap it with EXCEPTION clause?
- Follow-Ups:
- Re: temp table existence
- From: Marcin Krawczyk
- Re: temp table existence
- From: Pavel Stehule
- Re: temp table existence
- Prev by Date: Re: sql query question ?
- Next by Date: Re: temp table existence
- Previous by thread: sql query question ?
- Next by thread: Re: temp table existence
- Indexes: