Re: How to check if a Procedure or FUNCTION EXIST - Mailing list pgsql-admin

From David G. Johnston
Subject Re: How to check if a Procedure or FUNCTION EXIST
Date
Msg-id CAKFQuwYPb9+Lei7qx4k87cLUHNcyt_BTpGGZd6gxQhSv_OCaNA@mail.gmail.com
Whole thread Raw
Responses Re: How to check if a Procedure or FUNCTION EXIST
List pgsql-admin
On Tue, May 27, 2025 at 8:02 AM Edwin UY <edwin.uy@gmail.com> wrote:
I want to check for function and procedure if they exist or not including those created by the users as well as system functions

Are you aware that even in the same schema multiple functions and procedures can share the same "name"?

 
proowner whether it is a system function or user-defined?


That seems like a poor test for that property.  A system function is one that exists in the pg_catalog schema, which is the schema the system places all of its objects into.

David J.

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Tables in public schema
Next
From: David Okeamah
Date:
Subject: Re: How to check if a Procedure or FUNCTION EXIST