my life

day to day

Method to cleanly DROP FUNCTIONs by wildcard in Postgres

May 30th, 2005

Cut and paste the output of this execution:


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

add to del.icio.us    add to technorati favs    email this

Leave a Reply