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.
Default table - coretable.foo
Client specific table client.foo
How can I check if a table or alternate view exists in schema B.
if client.foo exists // check for a view or table
// my code will use client.foo table
// my code will use coretable.foo
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
pgsql-general by date
|Next:||From: Jorge Godoy||Date: 2008-04-01 03:13:42|
|Subject: Re: Check if table or View exists|
|Previous:||From: Clemens Schwaighofer||Date: 2008-04-01 01:11:33|
|Subject: Re: Survey: renaming/removing script binaries