[QGIS-trac] [Quantum GIS] #2662: [Patch] custom query in postgres provider

[Quantum GIS]

#2662: [Patch] custom query in postgres provider
--------------------------------------+-------------------------------------
   Reporter:  brushtyler              |              Owner:  nobody       
       Type:  patch                   |             Status:  new          
   Priority:  minor: annoyance        |          Milestone:  Version 1.5.0
  Component:  Data Provider           |            Version:  HEAD         
   Keywords:  custom query, postgres  |   Platform_version:               
   Platform:  All                     |           Must_fix:  No           
Status_info:  0                       |  
--------------------------------------+-------------------------------------
 The patch permit you to load a postgres layer using a custom query, like
 {{{ SELECT * FROM tbl1 JOIN tbl2 ON tbl1.gid = tbl2.id WHERE tbl1.gid > 15
 LIMIT 10 OFFSET 15 }}}.

 The new layer have only select capabilities.

 The only limit is that no columns with the same name must be in the
 result.

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/2662>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats