Method to cleanly DROP FUNCTIONs by wildcard in Postgres

Cut and paste the output of this execution:


SELECT 'DROP function ' || proname || ' ('|| oidvectortypes(proargtypes) || ') CASCADE;' from pg_proc WHERE proname ~ '^create_product$';

No related posts.

Leave a Reply

Your email address will not be published. Required fields are marked *

*