Guest User

Untitled

a guest
Jun 21st, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION clone_schema_data(source_schema text, dest_schema text) RETURNS void AS
  2. $BODY$
  3. DECLARE
  4. objeto text;
  5. BEGIN
  6. FOR objeto IN
  7. SELECT table_name::text FROM information_schema.TABLES WHERE table_schema = source_schema
  8. LOOP
  9. IF objeto != 'schema_migrations' THEN
  10. EXECUTE 'INSERT INTO ' || dest_schema || '.' || objeto || '(SELECT * FROM ' || source_schema || '.' || objeto || ')';
  11. END IF;
  12. END LOOP;
  13. END;
  14. $BODY$
  15. LANGUAGE plpgsql VOLATILE;
Add Comment
Please, Sign In to add comment