RE: Re: Test for existence of Table

>-----Original Message-----
>From: Gregory Wood [mailto:gregw@com-stock.com]
>Sent: Thursday, January 04, 2001 9:12 PM
>To: PostgreSQL-General
>Subject: [GENERAL] Re: Test for existence of Table
>
>
>> DROP TABLE employees
>Error: ERROR:  Relation 'employees' does not exist
>
>And execution halts.... which is I believe why he wanted to check for the
>existence before trying to DROP. I'd love to know if this exists as well...
>would come in very handy during development time.
>

Execution does not halt, it continues and creates the table.  I rely on this
functionality, so I know it works.  Good luck!

>
>Greg

Cheers,
Craig