Postgres Pro
Downloads
Home   >   mailing lists

Dropping functions from pg_proc table w/ querry - Mailing list pgsql-admin

From Wells Oliver
Subject Dropping functions from pg_proc table w/ querry
Date
Msg-id CAOC+FBWN5bf56SwUbnhbymt0c_bmS6+-C1aiPwNOPe089+DqHA@mail.gmail.com
Whole thread Raw
Responses Re: Dropping functions from pg_proc table w/ querry  (Ian Barwick <ian.barwick@2ndquadrant.com>)
List pgsql-admin
Tree view
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.

--

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: the difference between psql , createdb, dropuser
Next
From: Wells Oliver
Date:
Subject: Upgrading from 9.6 to 12 and running into cast issues with pg_catalog.text()