first off, thanks for the education - i did learn a
lot about COPY and its options.
my problem was that openoffice.org asks for a text
delimiter and offers two choices, ' and ". COPY
chokes on both these options (at least in this case).
i think using the text delimiter cause nuls to be fed
in as text - since it was delimited.
in any case, one can over ride the two options by
highlighting one or the other (whichever is selected)
and then deleting it altogether. voila, no text
delimiter, no problem.
i had this issue before, but i found it unintuitive to
highlight and delete from a drop down box so it didn't
register right away.
sorry for the confusion and i hope this exercise helps
someone else who is importing OOo data into psgsql.
thanks again.
oe1
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com