Re: Copy Data Question

> >> i Start -> Run-> type "cmd" and press enter
> >> i then type....
> >> COPY t_temp FROM C:\parts.csv'
>
> >> and i get the following error:
> >> "The system cannnot find the file specified."
>
> I'll bet doubling the backslash would help.

okay, i canned using cmd in windows and i went with
the query tool in pgadmin3.

i have it so it almost works, but...

i have 11 columns total.  column 1, 2, 3, 4, 5 and 6
are NOT NULL.  the rest can be null and, in the case
of the imported data set, are null.

how do i manage this in the spreadsheets?

i tried leaving the extra cells empty - i received an
invalid data type for the first column without data.

i tried putting in '' each of the 5 empty columns and
i received the following error:

ERROR:  value too long for type character varying(4)
CONTEXT:  COPY t_temp, line 1, column
test_procedures_revision: "''''''"

i'm using tab delimited for the field delimiter.

as always, any guidance is much appreciated.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com