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

2009-01-08 Thread Tom Lane
Sherman Brown 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 arra

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

2009-01-08 Thread Richard Huxton
Sherman Brown wrote: > CREATE TABLE mp3.songs > ( > "Name" character varying[] NOT NULL, > "Artist" character varying[] NOT NULL, > "Composer" character varying[], > "Album" character varying[] NOT NULL, ... > Here are the first 4 lines from my CSV file: > Name,Artist,Composer,Album,Groupi