<div>
You can just execute DROP function without checking the result of this step - this way the error that will be raised if it does not exist is ignored.
</div>


You can just execute DROP function without checking the result of this step - this way the error that will be raised if it does not exist is ignored.

<div>
Thanks for this. &nbsp;I am learning PostgreSQL with 10 years of SQL Server background and was searching for the if exists() equivilant...I guess you get so caught up in one way, you miss the obvious... &nbsp;Thank YOU!!!! &nbsp;:-)
</div>


Thanks for this.  I am learning PostgreSQL with 10 years of SQL Server background and was searching for the if exists() equivilant...I guess you get so caught up in one way, you miss the obvious...  Thank YOU!!!!  :-)

<div>
<div class="content wysiwyg-content">
I am creating a SQL Script in PostgreSQL. &nbsp;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:<br />
<br />
IF My_Function() EXISTS <br />
<br />
THEN DROP My_Function();<br />
<br />
CREATE FUNCTION My_Function();
</div>
</div>


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();

PostgreSQL check if object Exists

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.