[postgis-users] import large multipolygon

Kevin Neufeld kneufeld at refractions.net
Fri Jul 4 12:53:39 PDT 2008

I don't have any problems loading your sql file into my database 
(running PG8.3.3, PGIS 1.3.3)

postgis=# \i testtable.sql
psql:testtable.sql:3: NOTICE:  CREATE TABLE will create implicit 
sequence "testtable_gid_seq" for serial column "testtable.gid"
psql:testtable.sql:3: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "testtable_pkey" for table "testtable"
  kneufeld.testtable.the_geom SRID:-1 TYPE:MULTIPOLYGON DIMS:2

(1 row)

postgis=# select ST_GeometryType(the_geom), ST_IsValid(the_geom), 
ST_NPoints(the_geom) from testtable;
  st_geometrytype | st_isvalid | st_npoints
  ST_MultiPolygon | t          |       8655
(1 row)

-- Kevin

sub3 wrote:
> Hi,
> I am having a problem.  I convert a shp file using shp2pgsql.  One of the
> multipolgons is very large (line is about 277k characters long).  After I
> import into postgresql, this geometry is empty.
> No error from postgis.
> No error from postgresql.
> I am only making a guess that it is the line size, I am not sure.  Is there
> a setting which would fix this?
> Thanks for any help.
> ---
> Attached is the .sql script.
> http://www.nabble.com/file/p18285042/testtable.sql testtable.sql 

More information about the postgis-users mailing list