shp2pgsql error under windows

From: Raivo Rebane <raivore55(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: shp2pgsql error under windows
Date: 2023-03-04 15:53:10
Message-ID: CAMH5fpuN47xpApTx-brMWdKX=GW3CcBF77qARTOsNKxUdrdRSw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I am usingPS F:\3D-data\Kataster> shp2pgsql -g piirid SHP_KATASTRIYKSUS
kataster > kataster.sql under Windows 10

And it’s output is full of zeroe

Cygwin helps to find them out,

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^@
^(at)U^@T^(at)F^@8^@;^(at)^M^@

^(at)S^@E^(at)T^@
^(at)S^@T^(at)A^@N^(at)D^@A^(at)R^@D^(at)_^@C^(at)O^@N^(at)F^@O^(at)R^@M^(at)I^@N^(at)G^@_^(at)S^@T^(at)R^@I^(at)N^@G^(at)S^@
^(at)T^@O^@ ^(at)O^@N^@;^(at)^M^@

^(at)B^@E^(at)G^@I^(at)N^@;^(at)^M^@

^(at)C^@R^(at)E^@A^(at)T^@E^@ ^(at)T^@A^(at)B^@L^(at)E^@ ^@"^(at)k^@a^(at)t^@a^(at)s^@t^(at)e^@r^@"^@
^@(^(at)g^@i^(at)d^@ ^(at)s^@e^(at)r^@i^(at)a^@l^@,^(at)^M^@

^@"^(at)t^@u^(at)n^@n^(at)u^@s^@"^@ ^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)2^@5^@)^@,^(at)^M^@

^@"^(at)h^@k^(at)o^@o^(at)d^@"^@ ^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)4^@)^@,^(at)^M^@

^@"^(at)m^@k^(at)_^@n^(at)i^@m^(at)i^@"^@ ^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)1^@0^(at)0^@)^@,^(at)^M^@

^@"^(at)o^@v^(at)_^@n^(at)i^@m^(at)i^@"^@ ^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)1^@0^(at)0^@)^@,^(at)^M^@

^@"^(at)a^@y^(at)_^@n^(at)i^@m^(at)i^@"^@ ^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)1^@0^(at)0^@)^@,^(at)^M^@

^@"^(at)l^@_^(at)a^@a^(at)d^@r^(at)e^@s^(at)s^@"^@
^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)2^@4^(at)0^@)^@,^(at)^M^@

^@"^(at)r^@e^(at)g^@i^(at)s^@t^(at)r^@"^@ ^(at)d^@a^(at)t^@e^@,^(at)^M^@

^@"^(at)m^@u^(at)u^@d^(at)e^@t^@"^@ ^(at)d^@a^(at)t^@e^@,^(at)^M^@

^@"^(at)s^@i^(at)h^@t^(at)1^@"^@ ^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)4^@5^@)^@,^(at)^M^@

^@"^(at)s^@i^(at)h^@t^(at)2^@"^@ ^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)4^@5^@)^@,^(at)^M^@

^@"^(at)s^@i^(at)h^@t^(at)3^@"^@ ^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)4^@5

How to generate proper sql output

Regards

Raivo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Moench-Tegeder 2023-03-04 16:05:36 Re: shp2pgsql error under windows
Previous Message Raivo Rebane 2023-03-04 15:33:20 shp2pgsql generates fake fail full of zeroes