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

[Carson Farmer]

Great thanks Jürgen, that did it!

Carson

On Tue, Apr 27, 2010 at 4:58 PM, Jürgen E. <jef at norbit.de> wrote:
> 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
>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>



-- 
Carson J. Q. Farmer
ISSP Doctoral Fellow
National Centre for Geocomputation
National University of Ireland, Maynooth,
http://www.carsonfarmer.com/