Re: Unknown character on copy
От
THOMPSON, JARED (ATTBAPCO)
Тема
Re: Unknown character on copy
Дата
Msg-id
377C0288D30BE04BA7B5FD60BDFC0C911A6F7004@crexc52p
Ответ на
Re: Unknown character on copy (Tom Lane)
Список
Дерево обсуждения
Unknown character on copy "THOMPSON, JARED (ATTBAPCO)" <JT060b@ATT.COM>
Re: Unknown character on copy Tom Lane <tgl@sss.pgh.pa.us>
Re: Unknown character on copy "THOMPSON, JARED (ATTBAPCO)" <JT060b@ATT.COM>
Re: Unknown character on copy "THOMPSON, JARED (ATTBAPCO)" <JT060b@ATT.COM>
> -----Original Message----- > From: Tom Lane [mailto:tgl@sss.pgh.pa.us] > > Is it also in the first line of the COPY data file? > > If so, it's probably a Unicode byte order mark. That's not really > legitimate in UTF8 data, but some Windows text editors are broken > enough > to insert one at the start of a file anyway. > > regards, tom lane Tom, thanks for the idea of the windows text editor - it was (apparently) the cause of the offending character. I dropped the table, and redid everything and the character showed up. So, I dropped the table - keeping all my processes the same with the exception of using gedit instead of windows notpad. The character did not show up. Thanks again, Jared
В списке pgsql-novice по дате отправления