Really easy problem...
| От | James David Smith |
|---|---|
| Тема | Really easy problem... |
| Дата | |
| Msg-id | CAMu32ABa_Tg3=bQRtN+JVhN+uzGAN2vkk25__vdyvqsivy8fRA@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Really easy problem...
|
| Список | pgsql-novice |
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);
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
В списке pgsql-novice по дате отправления: