Re: SQL: how to find if a table exists?

From: dima <_pppp(at)mail(dot)ru>
To: Jean-Christian Imbeault <totsubo2001(at)netscape(dot)net>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: SQL: how to find if a table exists?
Date: 2002-09-09 15:53:32
Message-ID: 3D7CC3FC.4050609@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Is there an SQL statement that will allow me to query a DB to see if a
> table exists?
select tablename from pg_tables?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Johnson, Shaunn 2002-09-09 16:09:55 Load sharing question
Previous Message Richard Huxton 2002-09-09 15:49:51 Re: Creating tons of tables to support a query