| From: | "Leif B(dot) Kristensen" <leif(at)solumslekt(dot)org> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Check if table exists |
| Date: | 2009-03-18 16:55:37 |
| Message-ID: | 200903181755.38024.leif@solumslekt.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Leif B. Kristensen | 2009-03-18 17:13:15 | Re: Check if table exists |
| Previous Message | Ed Hudspeth | 2009-03-18 15:02:07 | Service start up error "The service name is invalid net helpmsg 2185" |