On Sat, 26 Jul 2008, "Ole Ekerhovd" <olehare(at)online(dot)no> writes:
> How can I test if a table is present in database?
WHERE table_name = '<TABLE>' AND
table_schema = '<SCHEMA>'
BTW, this query is portable across database systems supporting
information schema, which is an almost defacto standard.
In response to
pgsql-sql by date
|Next:||From: Allan Kamau||Date: 2008-07-26 13:17:56|
|Subject: Efficiently determining the number of bits set in the contents of
a VARBIT field|
|Previous:||From: Anoop G||Date: 2008-07-26 05:33:26|
|Subject: Re: Test if a table is present|