Re: Import CSV date issues

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Import CSV date issues
Дата
Msg-id CAHyXU0wKjFdJX2KSvaC+n4ZDnA0dJ=QPcQ2Or=KrkSGgF-1e0Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Import CSV date issues  (Sarfraz Nawaz <sarfraz@gmail.com>)
Список pgsql-novice
On Sun, Mar 3, 2013 at 2:48 PM, Sarfraz Nawaz <sarfraz@gmail.com> wrote:
> Tom you are a legend! There were invisible characters at the start of
> the file which were not being shown with "head" and "cat". Removing
> them fixed the issue and copy worked like a charm. Thank you!

yup -- many utilities (especially on windows) are aware of BOM and
will suppress it.  hexdump is a good way to catch it out.  Ideally you
can disable BOM creation on whatever is producing your csv.

merlin


В списке pgsql-novice по дате отправления:

Предыдущее
От: Sarfraz Nawaz
Дата:
Сообщение: Re: Import CSV date issues
Следующее
От: Joseph Pravato
Дата:
Сообщение: Re: PostgreSQL Query Speed Issues