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
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 |