I am trying to import a CSV file into PgAdmin (Postgres 9.2 with PostGIS 2.2.0 extension).
I have created a new table and I'm now trying to insert the CSV file into it using the COPY statement.
COPY tablename FROM 'C:/temp/file.csv' DELIMETERS ',' CSV HEADER;However, I'm running into an error:
This is the first row of my CSV-file (below the header).
Do any of you know what I'm doing wrong?
أكثر...
I have created a new table and I'm now trying to insert the CSV file into it using the COPY statement.
COPY tablename FROM 'C:/temp/file.csv' DELIMETERS ',' CSV HEADER;However, I'm running into an error:
This is the first row of my CSV-file (below the header).
Do any of you know what I'm doing wrong?
أكثر...