Navigation :

CopyTopology

CopyTopology
Prev   8.5. Topology Constructors   Next

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

Prev   Up   Next
CreateTopology  Home  ST_InitTopoGeo