I am creating a SQL Script in PostgreSQL. I need it to check if a function exists in the database and if so, I need to execute the drop first and then a CREATE...the pseudo code would be something like this:
IF My_Function() EXISTS
THEN DROP My_Function();
CREATE FUNCTION My_Function();
Start Free Trial