[postgis-devel] [PostGIS] #572: Password whitespace for Shape File to PostGIS Importer not supported

PostGIS trac at osgeo.org
Tue Aug 17 14:51:26 PDT 2010


#572: Password whitespace for Shape File to PostGIS Importer not supported
-----------------------------------------+----------------------------------
 Reporter:  dandy                        |       Owner:  pramsey      
     Type:  defect                       |      Status:  new          
 Priority:  medium                       |   Milestone:  PostGIS 1.5.2
Component:  postgis                      |     Version:  1.5.X        
 Keywords:  password shapefile importer  |  
-----------------------------------------+----------------------------------

Comment(by pramsey):

 Yes, the password string builder plops the password in verbatim, which
 means you get something like
 {{{
   dbname=foo user=bar password=pass word
 }}}
 This link gives some advice on how to construct a string with spaces

 http://php.net/manual/en/function.pg-connect.php

 Since solution 'is to' use single-quotes, that means that passwords with
 single-quotes must be themselves escaped
 {{{
   dbname=foo password='pass word\'s'
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/572#comment:1>
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-devel mailing list