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