Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. $do$
  2. BEGIN
  3. FOR yyyy in 2012..2016 THEN
  4. EXECUTE $$COPY table$$||yyyy||$$ FROM 'E:datafile$$||yyyy||$$.csv DELIMITER ',' CSV;$$;
  5. END LOOP;
  6. END;
  7. $do$ LANGUAGE plpgsql
  8.  
  9. BEGIN;
  10.  
  11. DO $$
  12. -- function stuff
  13.  
  14. -- but if you use a exception, you will force a rollback
  15. RAISE EXCEPTION 'message';
  16. $$ LANGUAGE 'plpgsql';
  17.  
  18. COMMIT; -- OR ROLLBACK
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement