[Qgis-developer] How to load a postgres layer using a custom query?

[Jürgen E. Fischer]

Hi Carson,

On Tue, 27. Apr 2010 at 16:07:37 +0100, Carson Farmer wrote:
> dbname='gis' host=localhost port=5432 user='cfarmer' password=xxxx'
> table="(select st_union from ireland_all_1)" sql=""

You still need to specify the key and a geometry column.  So it might be:

dbname='gis' host=localhost port=5432 user='cfarmer' password=xxxx key=id table="(select id,st_union from ireland_all_1)" (st_union) sql=


Jürgen

-- 
Jürgen E. Fischer         norBIT GmbH               Tel. +49-4931-918175-20
Dipl.-Inf. (FH)           Rheinstraße 13            Fax. +49-4931-918175-50
Software Engineer         D-26506 Norden               http://www.norbit.de

-- 
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502