[postgis-users] Shp2pgsql load error

[strk at refractions.net]

On Tue, May 24, 2005 at 12:53:57PM -0400, Kralidis,Tom [Burlington] wrote:
> 
> Hi,
> 
> Thanks for the previous help on the encoding issues.  When trying again
> with the following command:
> 
> $ /usr/local/pgsql/bin/shp2pgsql -W ISO8859-1 -s 42304 wshed_p
> public.wshed_p | /usr/local/pgsql/bin/psql -d devgeodb -U postgres 
> 
> ERROR:  unterminated quoted string at or near
> "'SRID=42304;<SNIP_TONS_OF_GEOMETRY>64BA4041F6365E936DC3F8400151CD483FBA
> 404199B6A0E30AC4F8406EA" at character 158
> LINE 1:
> ...066.31678','281229.63625','485','01AM','Oromocto','SRID=4230...
> 
> Any suggestions?

First of all redirect to a file instead of piping.
Then run psql -f on that file, so the error will tell you 
line number causing it.
Collapse your TONS of geometry and see what sound wrong in quoting.

--strk;