Re: Import CSV date issues - Mailing list pgsql-novice

From Merlin Moncure
Subject Re: Import CSV date issues
Date
Msg-id CAHyXU0wKjFdJX2KSvaC+n4ZDnA0dJ=QPcQ2Or=KrkSGgF-1e0Q@mail.gmail.com
Whole thread Raw
In response to Re: Import CSV date issues  (Sarfraz Nawaz <sarfraz@gmail.com>)
List 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 by date:

Previous
From: Sarfraz Nawaz
Date:
Subject: Re: Import CSV date issues
Next
From: Joseph Pravato
Date:
Subject: Re: PostgreSQL Query Speed Issues