PostGIS: register column "geometry" without AddGeometryColumn

Question

The usual way to create a geometry column is AddGeometryColumn , however I need to work with existing columns, so I cannot use this function (as far as I know).

Thanks to the PostGIS docs , I can already register a column in the geometry_columns table , however AddGeometryColumn seems to do more than create a column and add a row to geometry_columns , for example, adds validations to a column.

---

So my question is: what do I need to do to register a column manually, in addition to adding a row to * geometry_columns *?

(for example, is there a modified version of AddGeometryColumn that works with an existing column?)

Answer 1

The easiest way to do this in existing columns is to use the Populate_Geometry_Columns function:
http://postgis.org/documentation/manual-1.5/Populate_Geometry_Columns.html

In other words: the function you are requesting already exists :-)

NTN Niklas

Answer 2

, AddGeometryColumn - , . , : , AddGeometryColumn .

"" "gis", SELECT INTO ?