text file problems

D. Hageman dhageman at dracken.com
Wed Oct 3 00:30:13 CDT 2001


An example of the line would be nice.  It could also be an unescaped 
character as well ...

On Tue, 2 Oct 2001, KUCHARSKI, DAVID R. wrote:

> I'm trying to load database info from a text file into postgresql.  the
> text files came with headers and everything.  those were stripped in VI
> leaving only the data to be imported.  using COPY FROM I was able to
> import 9 0f 15 files no problem.  6 are giving me fits.  I'm thinking
> that there is some unreadable control character that is gumming up the
> works.  does anyone know of a way to view these unreadable characters so
> that I can try to get the files loaded?
> 
> thanks
> Dave Kucharski
> 
> 
> 
> 

-- 
//========================================================\
||  D. Hageman                    <dhageman at dracken.com>  ||
\========================================================//




More information about the Kclug mailing list