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

ERROR: invalid input syntax for integer:

From: e-letter <inpost(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: ERROR: invalid input syntax for integer:
Date: 2011-09-21 23:04:07
Message-ID: CAET1fe6jM6V-FFoA=1jvBT+5vuGcONjXKUB=wjaP9MrmZiLUAw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Readers,

A database table was created with the command:

CREATE TABLE tablename (column1 bigint,date date,time time,column2 text)

a csv file was imported, of structure:

123456,2000-01-01,01:10,"sometext"

Using the command:

\copy tablename from file.csv

Causes the command terminal error:

 input syntax for integer: "123456,2000-01-01,01:10,"sometext""
CONTEXT:  COPY tablename, line 1, column column2: "123456

What is my mistake please?

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2011-09-22 00:07:04
Subject: Re: ERROR: invalid input syntax for integer:
Previous:From: Tom LaneDate: 2011-09-21 15:11:18
Subject: Re: query question

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