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

From George Weaver
Subject Using copy with a file containing blank rows
Date
Msg-id FD185BE0E2D0486987390B97953292C9@D420
Whole thread Raw
Responses Re: Using copy with a file containing blank rows  (Adrian Klaver <adrian.klaver@gmail.com>)
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


pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Backups
Next
From: Rob Sargent
Date:
Subject: Re: Did xpath_table get dropped.