Postgresql function after ALTER SCHEMA public RENAME to public_copy;

00-before.sql

CREATE OR REPLACE FUNCTION public.get_locations()
  RETURNS SETOF public.locations AS
$BODY$
DECLARE
l_record public.locations;
BEGIN

FOR l_record IN
SELECT * FROM public.locations
ORDER BY location_desc
LOOP

RETURN NEXT l_record;
END LOOP;

END;
$BODY$
  LANGUAGE plpgsql VOLATILE SECURITY DEFINER
  COST 10
  ROWS 10;

01-after.sql

CREATE OR REPLACE FUNCTION public_copy.get_locations()
  RETURNS SETOF public_copy.locations AS
$BODY$
DECLARE
l_record public.locations;
BEGIN

FOR l_record IN
SELECT * FROM public.locations
ORDER BY location_desc
LOOP

RETURN NEXT l_record;
END LOOP;

END;
$BODY$
  LANGUAGE plpgsql VOLATILE SECURITY DEFINER
  COST 10
  ROWS 10;