[postgis-tickets] [PostGIS] #4209: Issues using pgsql2shp with a postgis table with null geometries

PostGIS trac at osgeo.org
Mon Oct 22 06:58:09 PDT 2018


#4209: Issues using pgsql2shp with a postgis table with null geometries
-------------------------+---------------------
  Reporter:  gabrimonfa  |      Owner:  pramsey
      Type:  defect      |     Status:  new
  Priority:  medium      |  Milestone:
 Component:  postgis     |    Version:  trunk
Resolution:              |   Keywords:
-------------------------+---------------------

Comment (by gabrimonfa):

 Table creation:

 {{{
 CREATE TABLE public.ticket_4209 (
     id integer NOT NULL,
     geom public.geometry(Polygon)
 );

 COPY public.ticket_4209 (id, geom) FROM stdin;
 1       \N
 2       \N
 3
 0103000000010000000500000000000000000000000000000000000000000000000000F03F0000000000000000000000000000F03F000000000000F03F0000000000000000000000000000F03F00000000000000000000000000000000
 \.
 }}}


 Command invocation:

 {{{
 pgsql2shp -f /tmp/test.shp -h host -u user -P password -g geom dbhame
 "SELECT * FROM public.ticket_4209"
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4209#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-tickets mailing list