MAPC/equitabletod — pull request #20 by arminakvn (2014-09-04 15:15:26+00:00)
Title: Staging

@beechnut this is how I do it for updating the database (I am sure there are better ways): connecting to the database and deleting the existing rows in psql command line, and then importing the csv again. The code is:

For station_areas table:

DELETE FROM station_areas WHERE id < 332;

COPY station_areas FROM 'station_areas.csv' DELIMITER ',' CSV HEADER;

And for data dictionaries table:

DELETE FROM dictionary_entries WHERE id < 147;

COPY dictionary_entries FROM 'dict.csv' DELIMITER ',' CSV HEADER ENCODING 'windows-1251';