[postgis-users] oid field

Ezequias Rodrigues da Rocha ezequias at recife.pe.gov.br
Tue Jun 20 05:09:34 PDT 2006


Aaron,

When you tell new versions you mean 8.1 ?

Another question, why this field does not appears in a "\d" command ?
and how to generate this field if my application does not generated it ?



Regards


Aaron Koning escreveu:
> 'oid' is a database generated field containing unique values (one for 
> each row). In previous versions of PostgreSQL it was created by 
> default, however in newer versions it is not generated by default. The 
> shp2pgsql loader creates a 'gid' field that also contains unique 
> values, therefore the need for oid is moot ( i.e. use gid instead of oid).
>
> Aaron
>
> On 6/19/06, *Ezequias Rodrigues da Rocha* <ezequias at recife.pe.gov.br 
> <mailto:ezequias at recife.pe.gov.br>> wrote:
>
>     Could someone tell me what oid field does ?
>
>     I am using JUMP to load data into PostGIS and it is not generating
>     this
>     king of column.
>
>     I just think it is a problem is becouse didn't load the
>     spatial_ref_sys
>     table yet.
>
>
>     Sincerely
>     Ezequias
>
>     _______________________________________________
>     postgis-users mailing list
>     postgis-users at postgis.refractions.net
>     <mailto:postgis-users at postgis.refractions.net>
>     http://postgis.refractions.net/mailman/listinfo/postgis-users
>     <http://postgis.refractions.net/mailman/listinfo/postgis-users>
>
>
>
>
> -- 
> +--------------------------------------------
> |  Aaron Koning
> |  Information Technologist
> |  Prince George, BC, Canada.
> +--------------------------------------------
> |  http://datashare.gis.unbc.ca/fist/
> |  http://datashare.gis.unbc.ca/gctp-js/
> +--------------------------------------------
> ------------------------------------------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>   

-- 
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com
msn:ezequias at hotmail.com
"the worst of democracies is still better than the best of dictatorship"




More information about the postgis-users mailing list