Test for existence of Table

Andy Koch <dfunct@telus.net>

From: Soma Interesting <dfunct@telus.net>
To: pgsql-general@postgresql.org
Date: 2001-01-04T19:39:56Z
Lists: pgsql-general
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