Guest User

Untitled

a guest
Nov 19th, 2017
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. st.execute("COPY inputdata FROM 'C:\Users\JAMES\Downloads\V24_Mike_110217_RemovedReturnTrips\RyderCombiner\AllNonMatchingWithColNames.csv' CSV HEADER DELIMITER ',';");
  2.  
  3. Class.forName("org.postgresql.Driver");
  4. Connection conn = DriverManager.getConnection("jdbc:postgresql://192.168.1.15:5432/postgres", "postgres", "pass");
  5.  
  6. Connection connection = DBUtil.getConnection("POSTGRES");
  7. String sql = "COPY inputdata FROM 'C:\Users\JAMES\Downloads\V24_Mike_110217_RemovedReturnTrips\RyderCombiner\AllNonMatchingWithColNames.csv' CSV HEADER DELIMITER ','";
  8. CopyManager copyManager = new CopyManager((BaseConnection)connection);
  9. copyManager.copyIn(sql);
Add Comment
Please, Sign In to add comment