Message-ID: <6451fea051cfa5a4bbc15941f1e2082216195d43.camel@cybertec.at>
Subject: Re: How to check if a Procedure or FUNCTION EXIST
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Edwin UY <edwin.uy@gmail.com>, Pgsql-admin
	 <pgsql-admin@lists.postgresql.org>
Date: Tue, 27 May 2025 23:36:32 +0200
In-Reply-To: 
 <CA+wokJ_fJphYtOFxd2nHV7P6B9YdhN3=cOcevGHXPd50iUvreQ@mail.gmail.com>
References: 
	<CA+wokJ_fJphYtOFxd2nHV7P6B9YdhN3=cOcevGHXPd50iUvreQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/6451fea051cfa5a4bbc15941f1e2082216195d43.camel%40cybertec.at>
Precedence: bulk

On Wed, 2025-05-28 at 03:01 +1200, Edwin UY wrote:
> Probably a dumb question of sorts.=C2=A0
> I want to check for function and procedure if they exist or not including=
 those
> created by the users as well as system functions
>=20
> Will querying pg_catalog.pg_proc be enough? Using prokind to check if it =
is function
> or procedure and proowner whether it is a system function or user-defined=
?

That would simply be

  SELECT pronamespace::regprocedure AS "schema",
         oid::regprocedure
  FROM pg_proc
  WHERE proname =3D 'whatever';

Yours,
Laurenz Albe