[postgis-tickets] [PostGIS] #2986: [raster] raster2pgqsql

[PostGIS]

#2986: [raster] raster2pgqsql
-------------------------+--------------------------------------------------
 Reporter:  rmorelli     |       Owner:  dustymugs    
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.1.5
Component:  raster       |     Version:  2.1.x        
 Keywords:               |  
-------------------------+--------------------------------------------------

Comment(by rmorelli):

 gdal_translate with escape character

 {{{
 gdal_translate -of jpeg PG:"host='localhost' port='5432' dbname='xxx'
 user='xxx' password='xxx' schema='raster' table='dem'
 where='filename=\'dem20_1.tif\'' mode='2' " test.jpg
 Warning 1: Cannot find information about raster.dem table in
 raster_columns view. The raster table loading would take a lot of time.
 Please, execute AddRasterConstraints PostGIS function to register this
 table as raster table in raster_columns view. This will save loading time.
 row number 0 is out of range 0..-1
 Errore di segmentazione
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2986#comment:10>
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.