Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- st.execute("COPY inputdata FROM 'C:\Users\JAMES\Downloads\V24_Mike_110217_RemovedReturnTrips\RyderCombiner\AllNonMatchingWithColNames.csv' CSV HEADER DELIMITER ',';");
- Class.forName("org.postgresql.Driver");
- Connection conn = DriverManager.getConnection("jdbc:postgresql://192.168.1.15:5432/postgres", "postgres", "pass");
- Connection connection = DBUtil.getConnection("POSTGRES");
- String sql = "COPY inputdata FROM 'C:\Users\JAMES\Downloads\V24_Mike_110217_RemovedReturnTrips\RyderCombiner\AllNonMatchingWithColNames.csv' CSV HEADER DELIMITER ','";
- CopyManager copyManager = new CopyManager((BaseConnection)connection);
- copyManager.copyIn(sql);
Add Comment
Please, Sign In to add comment