On Monday, February 06, 2012 9:43:35 pm Lockas wrote: > OK .. my offending line number is 4533 > How can i remove it while copying ? As others have said if it is just the one line remove it manually and then do the COPY. If there are many lines and if you will dealing with this on a recurring basis I would suggest taking a look at pgloader: http://pgloader.projects.postgresql.org/ There is a bit of learning curve, but it will do the clean up for you. -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
