Drop function syntax and example

PostreSQL tutorial – Drop function

Drop postgresql function

Drop function if exists. Syntax and example.

Syntax

DROP FUNCTION [ IF EXISTS ] 
function_name 
( [ [ argmode ] [ argname ] 
argtype [, ...] ] ) [ CASCADE | RESTRICT ];

Example

DROP FUNCTION 
set_customers(p_first_name varchar, p_last_name varchar);

Create Function |
Alter Function