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 <[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 > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
