Populate_Topology_Layer — 通过从拓扑表读取元数据，将缺失的条目添加到topology.layer表中。
setof record Populate_Topology_Layer();
通过检查表上的拓扑约束将缺失的条目添加到topology.layer 表中。 此功能对于在使用拓扑数据恢复模式后修复拓扑目录中的条目非常有用。
它返回创建的条目列表。 返回的列是 schema_name、table_name、feature_column。
可用性：2.3.0
SELECT CreateTopology('strk_topo');
CREATE SCHEMA strk;
CREATE TABLE strk.parcels(gid serial, parcel_id varchar(20) PRIMARY KEY, address text);
SELECT topology.AddTopoGeometryColumn('strk_topo', 'strk', 'parcels', 'topo', 'POLYGON');
createtopology
----------------
1
(1 row)
CREATE SCHEMA
CREATE TABLE
addtopogeometrycolumn
-----------------------
1
(1 row)
This query returns no records because the feature is already registered.
SELECT * FROM topology.Populate_Topology_Layer();
(0 rows)
Rebuild the topology layer catalog.
TRUNCATE TABLE topology.layer;
TRUNCATE TABLE
SELECT * FROM topology.Populate_Topology_Layer();
schema_name | table_name | feature_column -------------+------------+---------------- strk | parcels | topo (1 row)
SELECT topology_id, layer_id,
schema_name AS sn, table_name AS tn, feature_column AS fc
FROM topology.layer;
topology_id | layer_id | sn | tn | fc
-------------+----------+------+---------+------
1 | 1 | strk | parcels | topo
(1 row)