Re: Using copy with a file containing blank rows
От | George Weaver |
---|---|
Тема | Re: Using copy with a file containing blank rows |
Дата | |
Msg-id | 4C295C8AE31C4909A2C7F8212199E931@D420 обсуждение исходный текст |
Ответ на | Using copy with a file containing blank rows ("George Weaver" <gweaver@shaw.ca>) |
Список | 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 по дате отправления: