From: | "Oliveiros d'Azevedo Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt> |
---|---|
To: | "James David Smith" <james(dot)david(dot)smith(at)gmail(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Really easy problem... |
Date: | 2012-08-02 11:26:01 |
Message-ID: | 89ED2F11C2EC47F2B45031FE3AA9E275@marktestcr.marktest.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Howdy, James,
Have you tried adding column names?
COPY master_table_interpolated (date_time, person_id) ...
?
Just took a look at this http://www.postgresql.org/docs/9.0/static/sql-copy.html
Best,
Oliver
----- Original Message -----
From: James David Smith
To: pgsql-novice(at)postgresql(dot)org
Sent: Thursday, August 02, 2012 12:12 PM
Subject: [NOVICE] Really easy problem...
Hi everyone,
I'm struggling with something which I'm sure should be REALLY easy. But I can't quite get it to work. I've got a CSV file with two columns which looks like the below:
2012-07-15 10:00:00, 1
2012-07-15 10:00:00, 2
2012-07-15 10:00:00, 3
2012-07-15 10:00:00, 4
2012-07-15 10:00:00, 5
I want to copy the data into this table:
CREATE TABLE master_table_interpolated(
date_time TIMESTAMP WITH TIME ZONE,
person_id INTEGER,
person_location GEOMETRY);
So the data from the CSV file should go into the first two columns of my table, and leave the final one blank. I use this query to pull the CSV file in, however I can't figure out how to map the data to the correct columns in my table.
COPY master_table_interpolated from 'C:/Program Files/PostgreSQL/9.0/data/basetime.csv' DELIMITERS ',' CSV;
Ideas please?
Thanks
James
From | Date | Subject | |
---|---|---|---|
Next Message | James David Smith | 2012-08-02 11:51:37 | Re: Really easy problem... |
Previous Message | James David Smith | 2012-08-02 11:12:11 | Really easy problem... |