CopyTopology — Makes a copy of a topology structure (nodes, edges, faces, layers and TopoGeometries).
integer CopyTopology(varchar existing_topology_name, varchar new_name
Creates a new topology with name
new_topology_name and SRID and precision taken from
existing_topology_name, copies all nodes, edges and faces in there, copies layers and their TopoGeometries too.
The new rows in topology.layer will contain synthesized values for schema_name, table_name and feature_column. This is because the TopoGeometry will only exist as a definition but won't be available in any user-level table yet.
This example makes a backup of a topology called ma_topo
SELECT topology.CopyTopology('ma_topo', 'ma_topo_bakup');