Re: Really easy problem...

----- Original Message -----

From: James David Smith

To: pgsql-novice@postgresql.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