From: | <operationsengineer1(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Copy Failure |
Date: | 2005-08-25 18:46:13 |
Message-ID: | 20050825184613.32891.qmail@web33302.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
hi all.
i'm trying to copy data from a csv file into a PGSQL
7.4 database. i tried tab delimited and i tried comma
delimted.
i placed both files in my c:\cygwin and typed the
following in pgadmin3:
COPY t_ipc_defect FROM '/IPC';
my table looks like this:
description
date
id
my data looks like this...
"Tie too loose",08/25/2005,"MA18"
i also tried this...
Tie too loose,08/25/2005,MA18
and this...
"Tie too loose","08/25/2005","MA18"
the error i receive is pretty consistent.
ERROR: missing data column "date"
CONTEXT: COPY defect, line 1: ""PI[] (this is me -
looks to be a small vertical rectangle) Spacer not in
contact with component and body","08/25/2005","MA18""
i created my source csv file from openoffice.org. i
will go through the motions again, except i will try a
single quote instead of a double quote to see if that
helps.
does anyone have any ideas?
tia...
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | kynn | 2005-08-25 19:31:45 | Selective authentication? |
Previous Message | William Yu | 2005-08-25 11:42:49 | Re: Transaction Questions |