[postgis-users] shp2pgsql and psql: Null values represented by \N

[Nicolas Ribot]

> Hi,
>
> I am on WindowsXP.
>
> I am using shp2pgsql to create SQL to load a table to posgresql/postgis.
> some columns have null values, and are represented by \N in the output from
> this command.  However, when executing the sql output by shp2pgsql, psql
> chokes on it, with the following error message (one of many identical except
> for the number):
>
> > psql:shp_roads2_raw.sql:28656: invalid command \N
> >

Hi,
Are you sure this is the first error message you see in the file ?
I often see this error message after other, more meaningful, errors.

Nicolas