> >
> > It works instead..
> > I saw that "geometry_columns" is a view but the method works.
>
> Works at doing what ? It probably just silently does nothing.
If I make the above command and I look into the geometry column view I can
see a row with my information added.
> What does this return ?
>
> SELECT f_table_name, f_geometry_column, srid, type
> FROM geometry_columns WHERE f_table_name = 'pointdata';
I'll try Monday at work..
> > The view created is correctly and immediately seen by qgis that loads
the
> > point data.
> > The only problem is that it takes a year to load it..
>
> That's because QGis scans the whole table since it's unable to find
> the type and srid information in the geometry_column table.
> Am I wrong ?
>
No it immediately find the type and srid information.
In qgis when I open a connection there is a layer called mypointdata and
it's seen as point feature. When I click on add layer qgis take a lot to
load it.
But I think It's a question of data to be loaded. In fact I tried to make
a new view with only 2 fields in it and qgis is much more fast on loading
it.
Pietro
--
View this message in context:
http://postgis.17.n6.nabble.com/How-to-make-some-geometry-column-visible-to-Qgis-tp5000570p5000607.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
