----- 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@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
