CopyTopology — Makes a copy of a topology (nodes, edges, faces, layers and TopoGeometries) into a new schema


integer CopyTopology(varchar existing_topology_name, varchar new_name);


Creates a new topology with name new_name, with SRID and precision copied from existing_topology_name The nodes, edges and faces in existing_topology_name are copied into the new topology, as well as Layers and their associated TopoGeometries.


The new rows in the topology.layer table contain synthetic values for schema_name, table_name and feature_column. This is because the TopoGeometry objects exist only as a definition and are not yet available in a user-defined table.

Availability: 2.0.0


Make a backup of a topology called ma_topo.

SELECT topology.CopyTopology('ma_topo', 'ma_topo_backup');