--
-- This function changes owner to user tables and sequences
--

CREATE OR REPLACE FUNCTION owner(text) RETURNS integer AS $$
DECLARE
	owner_name ALIAS FOR $ 1 ;
	tbl_name RECORD;
	sec_name RECORD;
BEGIN
	-- Alter table owner
	FOR tbl_name IN SELECT relname FROM pg_statio_user_tables LOOP
		RAISE NOTICE 'Table: % altered to %', tbl_name.relname , owner_name;
		EXECUTE 'ALTER TABLE ' || tbl_name.relname || ' OWNER TO ' || owner_name;
	END LOOP;
	-- Alter sequence owner
	FOR sec_name IN SELECT relname FROM pg_statio_user_sequences LOOP
		RAISE NOTICE 'Sequence: % altered to %', sec_name.relname, owner_name;
		EXECUTE 'ALTER SEQUENCE ' || sec_name.relname || ' OWNER TO '  || owner_name;
	END LOOP;
	RETURN  1 ;
END;
$$ LANGUAGE plpgsql;

SELECT  1  FROM owner(owner_name);