Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem importing a csv file - Mailing list pgsql-general

From Shoaib Mir
Subject Re: Problem importing a csv file
Date
Msg-id CABAdwW1HEDqegVpZz9gmNArA-=dXo9i-WvkqcL0D2QD9AgbfUg@mail.gmail.com
Whole thread Raw
In response to Re: Problem importing a csv file  (planas <jslozier@gmail.com>)
List pgsql-general
Tree view
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 

pgsql-general by date:

Previous
From: planas
Date:
Subject: Re: Problem importing a csv file
Next
From: Tom Lane
Date:
Subject: Re: pg_restore with -j fails (works without -j option)