Has anyone achieved this in some way?
My functions are very simple like below, but I have 100s of them so need a way to do in bulk, even if it's by copying and replacing text in the dump file
Code: Select all
CREATE OR REPLACE FUNCTION query_add_added_to_recipe(date, bigint)
RETURNS void AS
'update recipe set added = $1 where id=$2'
LANGUAGE sql VOLATILE
COST 100;