Attempting to follow the instructions as written in the readme and example SQL did not result in data being loaded correctly into a PostgreSQL.
The following issues were encountered:
The documentation in the DOCs.md did not match the actual table structure (fixed in 1238035)
The data would not load with the given column types in create_tables.sql (fixed in fedf46c and 314693f)
The given COPYhas multiple problems (fixed in bbbe2fe)
COPY will only work on the postgresql server - so the option to load from the client should exist - added an \copy example
The awk command strips off the header from each file, but the the HEADER option will strip off an additional line from the input because it thinks its the header line, and there is no header line.
Use E'\t' to make the sql copy / paste friendly
make sure to state that {path} must be a full path when loading from the postgresql server.
Overview
Attempting to follow the instructions as written in the readme and example SQL did not result in data being loaded correctly into a PostgreSQL.
The following issues were encountered:
create_tables.sql
(fixed in fedf46c and 314693f)COPY
has multiple problems (fixed in bbbe2fe)COPY
will only work on the postgresql server - so the option to load from the client should exist - added an\copy
exampleHEADER
option will strip off an additional line from the input because it thinks its the header line, and there is no header line.E'\t'
to make the sql copy / paste friendly{path}
must be a full path when loading from the postgresql server.