Re: Problem importing a csv file

[Shoaib Mir <shoaibmir@xxxxxxxxx>]

On Mon, Aug 29, 2011 at 11:21 AM, planas <jslozier@xxxxxxxxx> wrote:

CREATE TABLE "ContactUpdates"
(
  "VendorID" integer NOT NULL,
  "LastName" character varying(45),
  "FirstName" character varying(45),
  CONSTRAINT "ContactUpdates_pkey" PRIMARY KEY ("VendorID" ) 

ERROR: relation "countupdates" does not exist
SQL state: 42P01
Adding ""
COPY "CountUpdates"
FROM '/media/Fred/Work/SQL_Server/AP/ContactUpdates.csv'
DELIMITER ',' CSV

ERROR:  relation "CountUpdates" does not exist

Table you created is "ContactUpdates" and you are trying to COPY data into "CountUpdates"? why do you think the error is not what you expected??

cheers,

Shoaib