Ciao Sandro I must premise that these are my first steps in using postgis, so, be patient. Then, isn't it possible to query data directly from the main "entities" table by creating views based on geometry type? Today I was testing this technique without success..
I have a big table (entities) with all the dxf geometries inside, with geometry column "wkb_geometry" and GEOMETRY as data type (srid 3004). My syntax is: create or replace view public.pointdata as select * from entities where layer like 'somepointlayer'; 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 create a view named pointdata but automatically set f_geometry_column = "wkb_geometry" (the name of the source geometry column) and type = GEOMETRY as in source table. So it doesn't seem to work.. I'll try your solution -- View this message in context: http://postgis.17.n6.nabble.com/How-to-make-some-geometry-column-visible-to-Qgis-tp5000570p5000596.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