[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