Postgres Pro
Downloads
Home   >   mailing lists

Re: drop table if exists mytable; - Mailing list pgsql-general

From Gurjeet Singh
Subject Re: drop table if exists mytable;
Date
Msg-id 65937bea0702100722s4698a95nf58c42816da6a5a6@mail.gmail.com
Whole thread Raw
In response to drop table if exists mytable;  ("Anton Melser" <melser.anton@gmail.com>)
List pgsql-general
Tree view
I am not sure if I understood the problem correctly!!!

Can you not use the standard command "DROP TABLE IF EXISTS table1" that PG provides?

http://www.postgresql.org/docs/8.2/interactive/sql-droptable.html

Or is it that you are on a version of PG where "IF EXISTS" syntax is not available?

Regards,

--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com

On 2/10/07, Anton Melser <melser.anton@gmail.com> wrote:
Hi,
I need to do a "drop table if exists" type thing. I realise I can
easily look in pg_tables, but for testing (if), don't I need to use a
procedural language? In which case, I will need to install it if it
doesn't exist - but I don't know how to test to see whether a language
exists without using a language!
Am I missing something simple here? Is there no way to do this outside
of a function?
Cheers
Antoine

pgsql-general by date:

Previous
From: "Anton Melser"
Date:
Subject: drop table if exists mytable;
Next
From: Andreas Kretschmer
Date:
Subject: Re: drop table if exists mytable;