Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL state: 22P02 Error during a COPY FROM a CSV file - Mailing list pgsql-general

From Tom Lane
Subject Re: SQL state: 22P02 Error during a COPY FROM a CSV file
Date
Msg-id 17306.1231433378@sss.pgh.pa.us
Whole thread Raw
In response to SQL state: 22P02 Error during a COPY FROM a CSV file  (Sherman Brown <ardcsb@earthlink.net>)
List pgsql-general
Tree view 
Sherman Brown <ardcsb@earthlink.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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: SQL state: 22P02 Error during a COPY FROM a CSV file
Next
From: Tom Lane
Date:
Subject: Re: version number between pgdump and server