[postgis-users] topologies

[Sandro Santilli]

On Tue, Mar 26, 2019 at 12:19:43PM +0000, paul.malm at lfv.se 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;