SQL Scripts for PostgreSQL (COPY error)

Hi @lee_evans

hmm, I still faced the same errors with the code but what I did was to modify the tables specs in the ddl instead of the COPY code:

  • for missing data, omit the column
  • for invalid input syntax, change from integer to varying character

Thanks,
Hui Xing