Re: drop table if exists mytable;
| От | Gurjeet Singh |
|---|---|
| Тема | Re: drop table if exists mytable; |
| Дата | |
| Msg-id | 65937bea0702100722s4698a95nf58c42816da6a5a6@mail.gmail.com обсуждение исходный текст |
| Ответ на | drop table if exists mytable; ("Anton Melser" <melser.anton@gmail.com>) |
| Список | pgsql-general |
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
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 по дате отправления: