[postgis-users] shp2pgsql

[Randy.Goss at kimley-horn.com]

I was loading a shapefile with a large number of nulls by piping shp2pgsql into psql and noticed that the loader is treating NULLs as a string when the dump_format option is not selected.  Removing the apostrophes from the line generating the nulls fixed the problem..i.e. changing (in the Insert_attributes function):

 printf(",'NULL'");

to 

 printf(",NULL");




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20020722/89b24c29/attachment.html>