Name

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

Synopsis

integer CopyTopology(varchar existing_topology_name, varchar new_name);

Description

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.

[Note]

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

Examples

Make a backup of a topology called ma_topo.

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

See Also

Section 4.5, “Spatial Reference Systems”, CreateTopology, RenameTopology