Re: SQL state: 22P02 Error during a COPY FROM a CSV file

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sherman Brown <ardcsb(at)earthlink(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SQL state: 22P02 Error during a COPY FROM a CSV file
Date: 2009-01-08 16:49:38
Message-ID: 17306.1231433378@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sherman Brown <ardcsb(at)earthlink(dot)net> writes:
> This is the table structure:
> CREATE TABLE mp3.songs
> (
> "Name" character varying[] NOT NULL,
> "Artist" character varying[] NOT NULL,
> "Composer" character varying[],

I'll bet a large amount of money that what you want is just plain
"character varying", not arrays of character varying.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-01-08 17:05:10 Re: version number between pgdump and server
Previous Message Richard Huxton 2009-01-08 16:37:11 Re: SQL state: 22P02 Error during a COPY FROM a CSV file