Postgres Pro
Downloads
Home   >   mailing lists

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

From Anton Melser
Subject drop table if exists mytable;
Date
Msg-id 92d3a4950702100644s58379953i2a0d73cd00d8096d@mail.gmail.com
Whole thread Raw
Responses Re: drop table if exists mytable;  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
Re: drop table if exists mytable;  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-general
Tree view 
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: Arturo Perez
Date:
Subject: Re: Adding TEXT columns tanks performance?
Next
From: "Gurjeet Singh"
Date:
Subject: Re: drop table if exists mytable;