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