Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Check if table exists
- From: "Leif B. Kristensen" <leif(at)solumslekt(dot)org>
- To: pgsql-novice(at)postgresql(dot)org
- Subject: Check if table exists
- Date: Wed, 18 Mar 2009 17:55:37 +0100
- Message-id: <200903181755.38024.leif@solumslekt.org> <text/plain>
Even if I've been using Postgres for some years, I figure that this
question fits best on this list:
How do I check if a table exists, eg. from a PLPGSQL function?
I've got a section of a function that only should be run if it's called
from a certain context, that is if the temporary table 'tmp_sources' is
found. But if I try with the line
IF EXISTS (SELECT * FROM tmp_sources) THEN
The function throws an error:
ERROR: relation "tmp_sources" does not exist
Which is kind of off the mark in my context.
--
Leif Biberg Kristensen | Registered Linux User #338009
Me And My Database: http://solumslekt.org/blog/
- Follow-Ups:
- Re: Check if table exists
- From: David Saracini
- Re: Check if table exists
- From: Semyon Chaichenets
- Re: Check if table exists
- From: Leif B. Kristensen
- Re: Check if table exists
- Prev by Date: Service start up error "The service name is invalid net helpmsg 2185"
- Next by Date: Re: Check if table exists
- Previous by thread: Service start up error "The service name is invalid net helpmsg 2185"
- Next by thread: Re: Check if table exists
- Indexes: