Editing of a topological dataset is different than doing so with Simple Features, as the data is relational and spans across multiple tables. In this section, the editing workflow for PostGIS topology will be discussed.
Topology editing
Adding new elements
First, we will add new features to the topology using two different methods. One approach is to use the standard ST_ functions. We will start with two isolated nodes. This is done with the topology.ST_AddIsoNode function. It takes three arguments: the topology name, the containing face ID (in our case, we will create nodes in empty space, so it will be NULL), and the point geometry:
SELECT topology.ST_AddIsoNode('my_topology',NULL,'SRID=4326;POINT(-1 1)');
st_addisonode
---------------
...