Re: shp2pgsql error under windows - Mailing list pgsql-general

From Christoph Moench-Tegeder
Subject Re: shp2pgsql error under windows
Date
Msg-id ZANsUHGrAqXSeHB7@elch.exwg.net
Whole thread Raw
In response to shp2pgsql error under windows  (Raivo Rebane <raivore55@gmail.com>)
List pgsql-general
## Raivo Rebane (raivore55@gmail.com):

> Raivo@DESKTOP-69FUU49 /cygdrive/f/3D-data/Kataster
> 
> $ cat kataster.sql | less
> 
> 
> 
> <FF><FE>S^@E^@T^@ ^@C^@L^@I^@E^@N^@T^@_^@E^@N^@C^@O^@D^@I^@N^@G^@ ^@T^@O^@

That's a BOM and the rest looks like UTF-16 (or UCS-2). You can use
recode (also available in Cygwin) to convert that. You could also use
shp2pgsql in Cygwin and be done with that (Windows is a quite bloated
bootloader for Cygwin, but you do you)).

Regards,
Christoph

-- 
Spare Space



pgsql-general by date:

Previous
From: Raivo Rebane
Date:
Subject: shp2pgsql error under windows
Next
From: Thorsten Glaser
Date:
Subject: Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y