Hi,
I have this plain text file with about 5000 lines.
Each line may have 4 or 5 fields, all delimited with a tab.
I've made a table named t_zip_codes with 5 fields.
When i run (in postgres command line) the command
COPY t_zip_code FROM zip_codes.txt;
it aborts as soon as it reaches a line with only 4 fields in the text
file, because the table t_zip_codes have 5 fields.
How can i solve this annoyance ?
All my fields are character varying.
Any help would be appreciated.
Warm regards,
Mário Gamito
