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

Anton Melser <melser.anton@gmail.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°