Re: using copy to load odd characters

--howdy:

--to reiterate the problem, i am simply doing
--a copy of a text file into a table:

[snip example]

testdb> \copy t_test1 from '/var/tmp/results.txt' with delimiter as '|'

[/snip example]

--the problem was that there were ^@ characters in the file
--and PostgreSQL didn't / couldn't load the data and terminated
--the process.

--my solution was to split the large files and, with VI,
--removed the ^@ characters by hand. the copy went
--as expected.

--i expected PostgreSQL to load the data, regardless
--of what was in the file. i'm only saying i 'expected'
--this because i've loaded the same file into the same
--table structure as DB2 (also my source for this file)
--and Oracle 9 with no problem. my apologies for assuming.

--i suppose my next question could be 'why couldn't
--PostgreSQL load characters like this into a table?'
--but it seems like the best thing for future events
--is to write a perl script to scan the text files and
--remove them before loading the data.

--thanks!

>Totally impossible to tell unless you tell us
>exactly what you are doing
>and what you expected out of it.

-X