PgCopy_2.java

String COPY = "COPY bike_trip (tripduration, starttime, stoptime,"
+ "start_station_id, start_station_name, start_station_latitude, "
+ "start_station_longitude, end_station_id, end_station_name,"
+ "end_station_latitude, end_station_longitude, bike_id,"
+ "user_type, birth_year, gender)"
+ " FROM STDIN WITH (FORMAT TEXT, ENCODING 'UTF-8', DELIMITER '\t',"
+ " HEADER false)";

int cont = 0;
StringBuilder sb = new StringBuilder();
Iterator<TripEntity> iterator = trips.iterator();
while (iterator.hasNext()) {
    TripEntity trip = iterator.next();
    sb.append(trip.getTripduration()).append("\t");
    sb.append(sdfDateTime.format(trip.getStarttime())).append("\t");
    sb.append(sdfDateTime.format(trip.getStoptime())).append("\t");
    sb.append(trip.getStartStationId()).append("\t");
    sb.append(trip.getStartStationName()).append("\t");
    sb.append(trip.getStartStationLatitude()).append("\t");
    sb.append(trip.getStartStationLongitude()).append("\t");
    sb.append(trip.getEndStationId()).append("\t");
    sb.append(trip.getEndStationName()).append("\t");
    sb.append(trip.getEndStationLatitude()).append("\t");
    sb.append(trip.getEndStationLongitude()).append("\t");
    sb.append(trip.getBikeId()).append("\t");
    sb.append(trip.getUserType()).append("\t");
    sb.append(nullify(trip.getBirthYear())).append("\t");
    sb.append(trip.getGender());
    sb.append("\n");
    cont++;