Check if table or View exists

Поиск
Список
Период
Сортировка
Искать
От
Jeff Williams
Тема
Check if table or View exists
Дата
Msg-id
18361.203.10.121.80.1207013701.squirrel@webmail-cp6.syra.net.au
Ответ на
Список
Дерево обсуждения
simple update queries take a long time - postgres 8.3.1 mark <markkicks@gmail.com>
Re: simple update queries take a long time - postgres 8.3.1 Raymond O'Donnell <rod@iol.ie>
Re: simple update queries take a long time - postgres 8.3.1 mark <markkicks@gmail.com>
Re: simple update queries take a long time - postgres 8.3.1 Raymond O'Donnell <rod@iol.ie>
Re: simple update queries take a long time - postgres 8.3.1 mark <markkicks@gmail.com>
Check if table or View exists "Jeff Williams" <jeff.williams@hardsoft.com.au>
Re: Check if table or View exists Jorge Godoy <jgodoy@gmail.com>
Re: simple update queries take a long time - postgres 8.3.1 Raymond O'Donnell <rod@iol.ie>
Re: simple update queries take a long time - postgres 8.3.1 mark <markkicks@gmail.com>
Re: simple update queries take a long time - postgres 8.3.1 mark <markkicks@gmail.com>
Re: simple update queries take a long time - postgres 8.3.1 Raymond O'Donnell <rod@iol.ie>
Re: simple update queries take a long time - postgres 8.3.1 Raymond O'Donnell <rod@iol.ie>
Re: simple update queries take a long time - postgres 8.3.1 Tomasz Ostrowski <tometzky@batory.org.pl>
Re: simple update queries take a long time - postgres 8.3.1 mark <markkicks@gmail.com>
Re: simple update queries take a long time - postgres 8.3.1 Tomasz Ostrowski <tometzky@batory.org.pl>
Re: simple update queries take a long time - postgres 8.3.1 Tom Lane <tgl@sss.pgh.pa.us>
Re: simple update queries take a long time - postgres 8.3.1 mark <markkicks@gmail.com>
Re: simple update queries take a long time - postgres 8.3.1 Tom Lane <tgl@sss.pgh.pa.us>
Re: simple update queries take a long time - postgres 8.3.1 mark <markkicks@gmail.com>
Re: simple update queries take a long time - postgres 8.3.1 mark <markkicks@gmail.com>
Re: simple update queries take a long time - postgres 8.3.1 Greg Smith <gsmith@gregsmith.com>
Re: simple update queries take a long time - postgres 8.3.1 mark <markkicks@gmail.com>
Re: simple update queries take a long time - postgres 8.3.1 Tomasz Ostrowski <tometzky@batory.org.pl>
Re: simple update queries take a long time - postgres 8.3.1 "Leif B. Kristensen" <leif@solumslekt.org>
Re: simple update queries take a long time - postgres 8.3.1 Colin Wetherbee <cww@denterprises.org>
Re: simple update queries take a long time - postgres 8.3.1 "Dave Page" <dpage@pgadmin.org>
Re: simple update queries take a long time - postgres 8.3.1 Greg Smith <gsmith@gregsmith.com>
Re: simple update queries take a long time - postgres 8.3.1 Greg Smith <gsmith@gregsmith.com>
Re: simple update queries take a long time - postgres 8.3.1 mark <markkicks@gmail.com>
Re: simple update queries take a long time - postgres 8.3.1 Greg Smith <gsmith@gregsmith.com>
Re: simple update queries take a long time - postgres 8.3.1 mark <markkicks@gmail.com>
Re: simple update queries take a long time - postgres 8.3.1 Tomasz Ostrowski <tometzky@batory.org.pl>
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.




В списке pgsql-general по дате отправления
От: Clemens Schwaighofer
Дата:
FAQ