DropGeometryColumn (original) (raw)

Name

DropGeometryColumn — Removes a geometry column from a spatial table.

Synopsis

text **DropGeometryColumn**(varchar table_name, varchar column_name);

text **DropGeometryColumn**(varchar schema_name, varchar table_name, varchar column_name);

text **DropGeometryColumn**(varchar catalog_name, varchar schema_name, varchar table_name, varchar column_name);

Description

Removes a geometry column from a spatial table. Note that schema_name will need to match the f_table_schema field of the table's row in the geometry_columns table.

This method implements the OGC Simple Features Implementation Specification for SQL 1.1.

This function supports 3d and will not drop the z-index.

This method supports Circular Strings and Curves.

| [Note] | | | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | | Changed: 2.0.0 This function is provided for backward compatibility. Now that since geometry_columns is now a view against the system catalogs, you can drop a geometry column like any other table column using ALTER TABLE | |

Examples

        SELECT DropGeometryColumn ('my_schema','my_spatial_table','geom');
        ----RESULT output ---
                          dropgeometrycolumn

my_schema.my_spatial_table.geom effectively removed.

-- In PostGIS 2.0+ the above is also equivalent to the standard -- the standard alter table. Both will deregister from geometry_columns ALTER TABLE my_schema.my_spatial_table DROP column geom;