Skip site navigation (1) Skip section navigation (2)

convert text file to database

From: e-letter <inpost(at)gmail(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: convert text file to database
Date: 2008-04-18 13:29:14
Message-ID: 298a6f60804180629i46d0ab41t7b5f95cd1b7e6d8c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Readers,

I re-formatted an extract from my file of chess matches to:

Event,Online Game,Site,www.flyordie.com,Date,yyyy/mm/dd,Round,1,White,djride,Black,kasparov777,Result,1-0,Termination,normal,UTCDate,2008/01/05,TimeControl,1200,moves,1.
c4 e5...25. Qh7# 1-0
Event,Online Game,Site,www.flyordie.com,Date,2008/01/05,Round,1,White,pawnsrow,Black,djride,Result,0-1,Termination,normal,UTCDate,yyyy/mm/dd,TimeControl,1200,moves,1.
d4 d5...33. Bf3 Rxe5 0-1

I tried to import the csv file using the command:

chessmatches=# COPY chessgames FROM '/absolute/path/filename.csv';
ERROR:  invalid input syntax for integer: "Event..."

CONTEXT:  COPY chessgames, line 1, column id: "Event,..."

My first thoughts are that I need to create a first column entitle
'column id' but there is no reference to the requirement for this in
the section of the manual COPY. SO what is required please?

Thanks,

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2008-04-18 14:49:52
Subject: Re: convert text file to database
Previous:From: Nils ZierathDate: 2008-04-18 08:36:11
Subject: Re: Remote / network connection fails

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group