[udig-users] Adding PostGIS Sql view

[César Arriaga Egües <carriaga@xxxxxxxxxx>]

Dear friends.

I have created a database view in Postgres/PostGIS based on two 1:1 related tables.

create view cat_building_v
  as select g.idbuilding, d.text, g.geom
  from cat_building_data d inner join cat_building_geo g
  on d.idbuilding = g.idbuilding;

I am trying to add this view to a new map in uDig but the view is not even listed in the "add layer from Postgis" wizzard.

I have been reading some posts of 2006 talking about the same issue, but in that time, it seem that the view could be listed in the same dialog.

Also checked the PostGIS geometry_columns view in which both cat_building_geo TABLE and cat_building_v VIEW are returned with the same attributes.

f_table_catalog f_table_schema  f_table_name          f_geometry_column coord_dimension srid    type
TestDB            public               cat_building_geo geom                 2               25830      POINT
TestDB            public               cat_building_v   geom                 2               25830      POINT

The same view can be rendered in QGIS with the same connection parameters (user).

Is there a way to render database views in uDig.

Thanks in advance.

César Arriaga.

________________________________

AVISO SOBRE CONFIDENCIALIDAD: La información incluida en este mensaje es CONFIDENCIAL y de uso EXCLUSIVO a su FINALIDAD. Su posterior divulgación será responsabilidad de quien la realice