Re: drop table if exists mytable;

Anton Melser <melser(dot)anton(at)gmail(dot)com> schrieb:

> Hi,
> I need to do a "drop table if exists" type thing. I realise I can

Install 8.2 or use this function, posted by David Fetter:

--
-- posted by David Fetter
--
CREATE OR REPLACE FUNCTION drop_table(TEXT)
RETURNS VOID
STRICT
LANGUAGE plpgsql
AS $$
BEGIN
BEGIN
EXECUTE 'DROP TABLE ' || $1;
EXCEPTION WHEN UNDEFINED_TABLE THEN
/* do nothing */
RETURN;
END;
RETURN;
END;
$$;

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°