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 по дате отправления
От: korry
Дата:
От: Clemens Schwaighofer
Дата: