Using copy with a file containing blank rows - Mailing list pgsql-general

Hi All,

I am trying to use COPY to import postgresql logs into a postgresql database
for further review and sorting.

The problem I'm encountering happens when COPY hits a blank row:

development=# COPY log
development-#  FROM
'D:/PostgreSQL/9.1/pg_log/postgresql-2012-03-15_093730.log'
development-#  WITH DELIMITER '^' NULL AS '';

ERROR:  missing data for column "ip_address"
CONTEXT:  COPY log, line 2: "   "

Line 2 is a blank line.

Is there any way to use COPY with blank lines or do the blank lines have to
removed before using COPY?

Thanks,
George