Hi Elijah, I had to learn this myself recently and it is really a PostGIS question as it applies (as far as i can tell to all software).
The query i was prompted to use to help fill in the necessary fields of the geometry_columns table was: INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type") SELECT '','public', 'VIEWTABLENAME', 'geometry', ST_CoordDim(geometry), ST_SRID(geometry), GeometryType(geometry) FROM public.VIEWTABLENAME LIMIT 1 This provides a listing by assessing the first row of your data. Hope it works as neatly for you as it did for me... i'm loving the power of views which is massively more effective that the same process in the GIS package we use. Best of luck Andy -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/PostGIS-Views-tp6583896p6584040.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ AppSumo Presents a FREE Video for the SourceForge Community by Eric Ries, the creator of the Lean Startup Methodology on "Lean Startup Secrets Revealed." This video shows you how to validate your ideas, optimize your ideas and identify your business strategy. http://p.sf.net/sfu/appsumosfdev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
