Check if table or View exists

From: "Jeff Williams" <jeff(dot)williams(at)hardsoft(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Check if table or View exists
Date: 2008-04-01 01:35:01
Message-ID: 18361.203.10.121.80.1207013701.squirrel@webmail-cp6.syra.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am developing an application where I will have a default table and/or
view for a select statement for my application. If a client has a special
requirement I would like to have a alternate table of the same name in a
different schema with the change structure.

Schema A
Default table - coretable.foo

Schema B
Client specific table client.foo

How can I check if a table or alternate view exists in schema B.

ie

if client.foo exists // check for a view or table
// my code will use client.foo table
else
// my code will use coretable.foo
endif

Also is it possible to check via function/via in postgress and not have to
rely on my application to do the check. If so how.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jorge Godoy 2008-04-01 03:13:42 Re: Check if table or View exists
Previous Message Clemens Schwaighofer 2008-04-01 01:11:33 Re: Survey: renaming/removing script binaries (createdb, createuser...)