[postgis-tickets] [PostGIS] #3701: Escape double quotes issue in pgsql2shp

[PostGIS]

#3701: Escape double quotes issue in pgsql2shp
----------------------+---------------------------
  Reporter:  kalxas   |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 2.3.3
 Component:  postgis  |    Version:  2.2.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by robe):

 okay I tried again with this, which might be what you meant.

 I started off with a table that has quotes in column:


 {{{

 So my dbf column ends up being quoteColumn.

 Anyrate, I think your quoting might still be off by a bit and seems like a
 waste of effort.

 I also tried this first creating a table:


 {{{
 SELECT ST_SetSRID(ST_Point(1,2)::geometry,4326)  AS "geom", 1 AS
 """quoteColumn" INTO testq;
 }}}


 Then outputing the table




 {{{  --run from psql
 SELECT ST_SetSRID(ST_Point(1,2)::geometry,4326)  AS "geom", 1 AS
 """quoteColumn" INTO testq;
 }}}

 Then I tried to export the table

 {{{
 pgsql2shp -r -g geom -f testq pgr testq
 }}}


 and it failed with your error.  So seems there is something wrong with our
 quote escaping logic.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3701#comment:3>
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.