| From: | Shoaib Mir <shoaibmir(at)gmail(dot)com> |
|---|---|
| To: | planas <jslozier(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Problem importing a csv file |
| Date: | 2011-08-29 01:38:42 |
| Message-ID: | CABAdwW1HEDqegVpZz9gmNArA-=dXo9i-WvkqcL0D2QD9AgbfUg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Aug 29, 2011 at 11:21 AM, planas <jslozier(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-08-29 01:56:40 | Re: pg_restore with -j fails (works without -j option) |
| Previous Message | planas | 2011-08-29 01:21:35 | Re: Problem importing a csv file |