RE: Re: Test for existence of Table - Mailing list pgsql-general

From Craig L. Ching
Subject RE: Re: Test for existence of Table
Date
Msg-id E1B42CFD544FD31193EE0000E87C5CE771015B@mailserver2.mqsoftware.com
Whole thread Raw
In response to Test for existence of Table  (Soma Interesting <dfunct@telus.net>)
List pgsql-general
>-----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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PL/pgSQL NOT NULL variables
Next
From: "Gregory Wood"
Date:
Subject: Re: Re: Test for existence of Table