[postgis-users] How to make some geometry column visible to Qgis

[Sandro Santilli]

On Fri, Oct 19, 2012 at 02:34:42AM -0700, Pietro Rossin wrote:
> 
> >> INSERT INTO geometry_columns (f_table_catalog,f_table_schema,
> >> f_table_name, 
> >> f_geometry_column, coord_dimension, srid,type) 
> >>   VALUES ('testdb','public', 'pointdata', 'geom', 3, 3004,'POINT'); 
> 
> >This shouldn't work, as "geometry_columns" is a view (assuming you
> correctly 
> >installed PostGIS-2.0).
> 
> 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.

What does this return ?

  SELECT f_table_name, f_geometry_column, srid, type
  FROM geometry_columns WHERE f_table_name = 'pointdata';

> 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 ? 

--strk;

 http://www.cartodb.com - Map, analyze and build applications with your data

                                       ~~ http://strk.keybit.net