Error uploading CSV to PostgreSQL

Question

I make table:

CREATE TABLE data (
date    date,
time    time,
val3    float,
val4    float);

And trying to load csv to it with next command:

copy data from 'G:\test\1.txt' DELIMETERS ' ' CSV;

the CSV have same structure:

date time val3 val4 
2012.08.10 06:53:18 695.417 773.29

But I am getting next error:

ERROR: invalid input syntax for type date: "date"

Could you help me to find the reason of error?

Community · Accepted Answer · 2017-05-23 12:29:19Z

1

I'm not very used to postgres, but I think you should set your datestyle before importing your file :

set datestyle German, YMD;

Sorry if I'm wrong, but I think you have to correctly set your datestyle (you can also do in the postgres.cnf file).

CommunityBot

11 silver badge

answered Jul 22, 2013 at 12:34

kmas

6,44913 gold badges44 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

It is better to use links to current version of postgres manual. /docs/current/static instead of /docs/8.2/static.

I had tried this command several times. It does not work with quote symbol. Plz look at my log postimg.org/image/51n25xr0z

bma · Accepted Answer · 2013-07-22 15:15:50Z

0

Do you have a header line in your CSV? If so, try

copy data from 'G:\test\1.txt' DELIMETERS ' ' CSV HEADER;

answered Jul 22, 2013 at 15:15

bma

9,8562 gold badges35 silver badges22 bronze badges