Dropping functions from pg_proc table w/ querry

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Dropping functions from pg_proc table w/ querry
Date: 2019-10-30 03:05:10
Message-ID: CAOC+FBWN5bf56SwUbnhbymt0c_bmS6+-C1aiPwNOPe089+DqHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have this query:

select * from pg_proc where probin like '%someoldstuff%';

Which shows abou 20 functions I want dropped. Is there a quick convenient
SQL query for dropping all of these? Can't quite figure it out.

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2019-10-30 03:17:40 Upgrading from 9.6 to 12 and running into cast issues with pg_catalog.text()
Previous Message David G. Johnston 2019-10-29 16:37:29 Re: the difference between psql , createdb, dropuser