Re: shp2pgsql error under windows

From: Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>
To: Raivo Rebane <raivore55(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: shp2pgsql error under windows
Date: 2023-03-04 16:05:36
Message-ID: ZANsUHGrAqXSeHB7@elch.exwg.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

## Raivo Rebane (raivore55(at)gmail(dot)com):

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thorsten Glaser 2023-03-04 20:00:33 Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y
Previous Message Raivo Rebane 2023-03-04 15:53:10 shp2pgsql error under windows