Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION clone_schema_data(source_schema text, dest_schema text) RETURNS void AS
- $BODY$
- DECLARE
- objeto text;
- BEGIN
- FOR objeto IN
- SELECT table_name::text FROM information_schema.TABLES WHERE table_schema = source_schema
- LOOP
- IF objeto != 'schema_migrations' THEN
- EXECUTE 'INSERT INTO ' || dest_schema || '.' || objeto || '(SELECT * FROM ' || source_schema || '.' || objeto || ')';
- END IF;
- END LOOP;
- END;
- $BODY$
- LANGUAGE plpgsql VOLATILE;
Add Comment
Please, Sign In to add comment