Skip site navigation (1) Skip section navigation (2)

Unable to copy data from csv file, solution of problem

From: e-letter <inpost(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Unable to copy data from csv file, solution of problem
Date: 2009-12-29 11:06:00
Message-ID: 298a6f60912290306r458bc4c3t221e7197ae590e14@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Readers,

This is for other novices that experienced the same error. Solved by
expert postgresql users at the irc channel.

I created a database and table successfully

I tried the following command and receiving the following command
terminal output:

CREATE TABLE test();
CREATE TABLE
...=# COPY activity FROM '/path/to/test.csv';
ERROR:  extra data after last expected column
CONTEXT:  COPY activity, line 1: "a,b"

The csv file is:

a,b
1,2

The error is due to the mistake of creating a blank table. It is
necessary to create a table with the columns configured to resemble
the columns in the csv file.

Columns can be configured manually using the 'create table' command
instructions, or use 'extract load transform' (ELT) software such as
pgloader, or kettle, or others.

pgsql-novice by date

Next:From: Susan M FarleyDate: 2010-01-04 00:29:15
Subject: How to create a Java function in PostgreSQL
Previous:From: Jasen BettsDate: 2009-12-29 02:40:03
Subject: Re: CHILD WITHOUT PARENT (TEMPORARILY)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group