pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
shp2pgsql error under windows
2+ messages / 2 participants
[nested] [flat]

* shp2pgsql error under windows
@ 2023-03-04 15:53 Raivo Rebane <raivore55@gmail.com>
  2023-03-04 16:05 ` Re: shp2pgsql error under windows Christoph Moench-Tegeder <cmt@burggraben.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Raivo Rebane @ 2023-03-04 15:53 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

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

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

^@B^@E^@G^@I^@N^@;^@^M^@

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

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

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

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

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

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

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

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

^@"^@m^@u^@u^@d^@e^@t^@"^@ ^@d^@a^@t^@e^@,^@^M^@

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

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

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



How to generate proper sql output



Regards



Raivo

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: shp2pgsql error under windows
  2023-03-04 15:53 shp2pgsql error under windows Raivo Rebane <raivore55@gmail.com>
@ 2023-03-04 16:05 ` Christoph Moench-Tegeder <cmt@burggraben.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Christoph Moench-Tegeder @ 2023-03-04 16:05 UTC (permalink / raw)
  To: Raivo Rebane <raivore55@gmail.com>; +Cc: pgsql-general@lists.postgresql.org

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2023-03-04 16:05 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-03-04 15:53 shp2pgsql error under windows Raivo Rebane <raivore55@gmail.com>
2023-03-04 16:05 ` Christoph Moench-Tegeder <cmt@burggraben.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox