Re: Unknown character on copy
| От | THOMPSON, JARED (ATTBAPCO) |
|---|---|
| Тема | Re: Unknown character on copy |
| Дата | |
| Msg-id | 377C0288D30BE04BA7B5FD60BDFC0C911A6F7004@crexc52p обсуждение исходный текст |
| Ответ на | Re: Unknown character on copy (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-novice |
> -----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 по дате отправления: