[postgis-users] How to make some geometry column visible to Qgis
Sandro Santilli
strk at keybit.net
Fri Oct 19 03:29:36 PDT 2012
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
More information about the postgis-users
mailing list