[PATCH] Re: AW: [postgis-users] shp2pgsql problems with NULL value columns

Steffen Macke sdteffen at web.de
Wed Aug 7 09:29:17 PDT 2002


> shp2pgsql -c -D adrstr_numpos adrstr DBname ¦ psql -d DBname

The dump format made the problem: psql expects \N instead of NULL here

replace 
printf("\tNULL");
in line 412 with
printf("\\N");

This is fixed in the attached patch.

Steffen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: patch-shp2pgsql-aug-07-2002.diff.gz
Type: application/x-gzip
Size: 332 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20020807/18e3ea37/attachment.bin>


More information about the postgis-users mailing list