On Mon, Aug 29, 2011 at 11:21 AM, planas
<jslozier@gmail.com> 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