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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
