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.
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...) |