On Sat, 26 Jul 2008, "Ole Ekerhovd" <[EMAIL PROTECTED]> writes: > How can I test if a table is present in database?
SELECT TRUE
FROM information_schema.tables
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.
Regards.
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
