[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [udig-users] Adding PostGIS Sql view
|
Hi, maybe you have found a bug. Could you attach the log? It is available in :
Help > Submit Issue
Please, provide some details about your installation (udig version, operating
system)
cheers
--
Mauricio Pazos
On Saturday, March 08, 2014 02:39:02 PM César Arriaga Egües wrote:
> 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
> _______________________________________________
> udig-users mailing list
> udig-users@xxxxxxxxxxxxxxxxxxxxx
> http://lists.refractions.net/mailman/listinfo/udig-users
