2

Hello.

When I used postgres 8.4 and postgis 1.5, I register tables (for example, for qgis) with coordinates in geometry_columns.

But now, in postgres 9.2 and postgis 2.0, geometry_columns it's view! And view geometry_columns consists of system tables, which names starts with 'pg_'. How can I insert or update row??

Kris Ku
  • 1,507
  • 1
  • 16
  • 32

1 Answers1

3

Use the PostGIS management functions, like AddGeometryColumn, DropGeometryColumn, etc.

Alternately, as documented in those pages, you can manually register columns.

Craig Ringer
  • 307,061
  • 76
  • 688
  • 778