search

NYCPlanning / data-loading-scripts

Scripts for loading data into capital planning databases
3 stars 2 forks source link

Issue with running copy.sql #4

Open AmandaDoyle opened 7 years ago

AmandaDoyle commented 7 years ago

When running copy.sql from node loader push xxxx the table name is replaced by whatever the file is called

(i.e. You have a copy statement that says: \COPY abcd FROM './temp/folder/ABCD.csv' CSV HEADER; if you are running node loader push XXXX the copy statement says \COPY XXXX FROM './temp/folder/ABCD.csv' CSV HEADER; and nothing gets copied