From: "Mário Gamito" <[EMAIL PROTECTED]> > 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 ?
by adding the 5th field where missing ? with something like: perl -pi.bak -e's/$/\t/ if tr/\t/\t/<4' zip_codes.txt should be easy with sed, as well (or just with your favorite editor) gnari ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly