[postgis-users] CREATE UNIQUE INDEX oid ON ...

Markus Schaber schabi at logix-tt.com
Thu Jun 29 07:06:54 PDT 2006


Ezequias Rodrigues da Rocha wrote:
> I did it but the field was created and no values are on it.
> 
> How to populate this kind of field ? This kind of field need to be
> populated ?

Yes, it needs to be populated with unique values. You can use UPDATE and
the nextval() sequence function for this.

Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org



More information about the postgis-users mailing list