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

[Düster Horst]

Hi Steffen

Thank you very much for your patch. Now it works fine. A little mistake in
your description below:

you wrote: 
...
in line 412 with
printf("\\N"); 

but correct is:
printf("\t\\N"); ;)

Horst

-----Ursprüngliche Nachricht-----
Von: Steffen Macke [mailto:sdteffen at web.de]
Gesendet am: Mittwoch, 7. August 2002 17:29
An: postgis-users at postgis.refractions.net
Betreff: [PATCH] Re: AW: [postgis-users] shp2pgsql problems with NULL
value columns

> 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