RE: Test for existence of Table

Yeah,

DROP TABLE employees
CREATE TABLE employees

;-)

Craig

-----Original Message-----
From: Soma Interesting [mailto:dfunct@telus.net]
Sent: Thursday, January 04, 2001 1:40 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Test for existence of Table


Can I test for an existing table before issuing the "CREATE TABLE" command?

IF EXISTS employees{
         DROP TABLE employees
}
CREATE TABLE employees

Can you provide an example of this. I couldn't find this in the manual or
Bruce's book - did I not look hard enough ? :)


-          -          -          -          -          -          -
  -          -          -          -
WARNING: Some experts believe that use of any keyboard may cause
serious injury. Consult Users Guide.

dfunct@telus.net