[postgis-users] geometry field doesn't show up in gvSig

[Fred Lehodey]

Hi,you just need to populate the table "geometry_columns" in the public
schema.

Example:
INSERT INTO  geometry_columns
 values('','public','your_table','the_geom',2,your_srid,'your_geometry')

Fred





On Fri, Oct 31, 2008 at 12:00 PM, stetou <Steve.Toutant at inspq.qc.ca> wrote:

>
> Hi,
> I have apostgis table that I can load in qgis but I can't with gvSig. In
> gvSig the Geometry field list box is empty so I can not complete the GeoBD
> wizard.
> I tried with other tables and it works. Maybe the way I created this table
> is not correct. Here is what I did:
> in the sql below ad2001 is a table with a geometry field visible in gvSig
> defavorisation2001 is a table without geometry
> I made a join from these 2 tables. Do you something wrong in the creation
> of
> this new table?
> thanks,
> steve
>
> select distinct a.gid, a.the_geom, b."ADIDU", b."QUINTMAT", b."QUINTSOC"
> into lim_admin.IndiceDefavorisation
> from lim_admin.ad2001 as a, lim_admin. defavorisation2001 as b
> where a."dauid" = b."ADIDU";
>
> alter table lim_admin.IndiceDefavorisation
>  add CONSTRAINT IndiceDefavorisation_pkey PRIMARY KEY (gid),
>  --add column idUnique serial PRIMARY KEY,
>  add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
>  add CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) =
> 'MULTIPOLYGON'::text OR the_geom IS NULL),
>  add CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 4326);
>
> CREATE INDEX IndiceDefavorisation_the_geom_gist
>  ON lim_admin.IndiceDefavorisation
>  USING gist
>  (the_geom);
> --
> View this message in context:
> http://www.nabble.com/geometry-field-doesn%27t-show-up-in-gvSig-tp20264514p20264514.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081031/70db4878/attachment.html>