On Tue, Mar 26, 2019 at 12:19:43PM +0000, [email protected] wrote: > My SQL: > CREATE TABLE merged AS( > SELECT fname, the_geom FROM public."RST_1813_UTM31N_WE_D_R_Line" > UNION > SELECT fname, the_geom FROM public."CTR_1813_UTM31N_WE_line"); > > SELECT Populate_Geometry_Columns('merged'::regclass); > > SELECT topology.CreateTopology('roads_topo', 32631); > SELECT topology.AddTopoGeometryColumn('roads_topo', 'public', 'merged', > 'topo_geom', 'LINESTRING'); > UPDATE merged SET topo_geom = topology.toTopoGeom(wkb_geometry, 'roads_topo', > 1, 1.0); > CREATE TABLE public."roads_clean" AS ( > SELECT topo_geom::geometry FROM merged); > > Nor I or pgAdmin 4 knows what wkb_geometry is, in the UPDATE command > (directly copied from the example). > Can someone please, help me?
You probably want to use the name of your geometry column, which seems to be "the_geom" from your `CREATE TABLE merged` statement. --strk; _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
