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

From George Weaver
Subject Re: Using copy with a file containing blank rows
Date
Msg-id 4C295C8AE31C4909A2C7F8212199E931@D420
Whole thread Raw
In response to Using copy with a file containing blank rows  ("George Weaver" <gweaver@shaw.ca>)
List pgsql-general
>----- Original Message -----
>From: Adrian Klaver

>On 03/15/2012 09:17 AM, George Weaver wrote:
>> Hi All,
>>
>> I am trying to use COPY to import postgresql logs into a postgresql
>> database for further review and sorting.

>Are you using the CSV format to log to the Postgres log?:
>http://www.postgresql.org/docs/9.1/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG

[life intervenes...]

Thanks Adrian - I wasn't using the CSV format - I am now!  It solves the
blank line problem I was encountering.

George

>>
>> 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?

>AFAIK, you have to remove blank lines.

>>
>> Thanks,
>> George
>>


--
Adrian Klaver
adrian.klaver@gmail.com


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Updates, ShareLocks, RowExclusiveLocks, and deadlocks
Next
From: Ben Chobot
Date:
Subject: Re: Updates, ShareLocks, RowExclusiveLocks, and deadlocks