[postgis-users] PostGIS view in qgis

[Randall, Eric]

Try OpenJump with the dbquery plugin.  You don't even need the view.
 
-Eric

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Martin Fafard
Sent: Monday, March 09, 2009 11:11 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] PostGIS view in qgis


Eduin

Thank you for the answer but it doesn't work. Since I create new objects from a view (polygonize), it seem to be impossible to create a unique id in this view for these objects. Someone else have ever aggregate geom in a view to see it in qgis or other viewer??

Martin F

Eduin Yezid Carrillo Vega a écrit : 

If your postgresql version is 8.0 or less you can use OID fields as

key identifier.



CREATE VIEW myview AS SELECT oid AS gid, the_geom FROM mytable;



In postgresql 8.3 you can force oid creation if WITH OIDS is specified

when the table is created





Eduin Yesid Carrillo Vega

Ingeniero Civil, Esp. Sistemas de Información Geográfica

Centro de Investigación y Desarrollo en Información Geográfica

Instituto Geográfico Agustín Codazzi - IGAC

Cr 30 48-51

Tel +57 1 3694000  ext 4593

Bogotá D.C., Colombia







On Mon, Mar 9, 2009 at 2:43 AM, Marc Jansen   <mailto:jansen.marc at gmx.de> <jansen.marc at gmx.de> wrote:

  

HI Martin,





Martin Fafard schrieb:

    

Hi



I polygonize linestrings in a view to see the result in qgis. But qgis

need gid. How can I create the gid column after an aggregate function in a

view?

      

AFAIK you can't. Maybe a table (created by your query) with a serial /

primary key helps.



--Marc







    

Martin F

_______________________________________________

postgis-users mailing list

postgis-users at postgis.refractions.net

http://postgis.refractions.net/mailman/listinfo/postgis-users



      

_______________________________________________

postgis-users mailing list

postgis-users at postgis.refractions.net

http://postgis.refractions.net/mailman/listinfo/postgis-users



    


  _____  



No virus found in this incoming message.

Checked by AVG -  www.avg.com 

Version: 8.0.237 / Virus Database: 270.11.9/1990 - Release Date: 03/08/09 17:17:00



    

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090309/a09c832d/attachment.html>