Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Check if table exists
- From: Semyon Chaichenets <pgsql-novice(at)semyon(dot)net>
- To: "Leif B. Kristensen" <leif(at)solumslekt(dot)org>
- Cc: pgsql-novice(at)postgresql(dot)org
- Subject: Re: Check if table exists
- Date: Wed, 18 Mar 2009 13:21:23 -0400
- Message-id: <6f81e0890903181021g2046c0p8f3b06aff8fff711@mail.gmail.com> <text/plain>
Try
IF EXISTS (SELECT * FROM pg_table WHERE tablename=tmp_sources)
THEN
-- table exists
Alternatively, you could try catching the exception in your original
code and handling it.
IF EXISTS (SELECT * FROM tmp_sources) THEN
-- table or view exists
EXCEPTION
Semyon
> How do I check if a table exists, eg. from a PLPGSQL function?
> IF EXISTS (SELECT * FROM tmp_sources) THEN
>
> The function throws an error:
>
> ERROR: relation "tmp_sources" does not exist
>
- References:
- Check if table exists
- From: Leif B. Kristensen
- Check if table exists
- Prev by Date: Re: Check if table exists
- Next by Date: Re: Check if table exists
- Previous by thread: Re: Check if table exists
- Next by thread: Re: Check if table exists
- Indexes: