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