Re: How to check if a Procedure or FUNCTION EXIST

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tuesday, May 27, 2025, Edwin UY <edwin.uy@xxxxxxxxx> wrote:

Hi David J

Just thought I will just have to check whether the proowner is one of the users/roles that we've created and if it is so, then it is not a system function.

By system function, I mean something like version or current_user, they are system functions, right? Or am I wrong again :(

I mean, so long as you never use/leave “postgres” (or whatever your bootstrap role name is) as the owner of a user-defined function it can work.  Schema just seems easier though…

David J.