Try OpenJump with the dbquery plugin. You don't even need the view. -Eric
-----Original Message----- From: [email protected] [mailto:[email protected]]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:[email protected]> <[email protected]> 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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] 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
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
