Name

Probe_Geometry_Columns — Scans all tables with PostGIS geometry constraints and adds them to the geometry_columns table if they are not there.

Synopsis

text Probe_Geometry_Columns();

Description

Scans all tables with PostGIS geometry constraints and adds them to the geometry_columns table if they are not there. Also give stats on number of inserts and already present or possibly obsolete.

[Note]

This will usually only pick up records added by AddGeometryColumn() function. It will not scan views so views will need to be manually added to geometry_columns table.

Examples

SELECT Probe_Geometry_Columns();
			probe_geometry_columns
---------------------------------------
probed:6 inserted:0 conflicts:6 stale:0
(1 row)

See Also

AddGeometryColumn