Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can anyone tell me what the purpose of the the geography_columns view and the geometry_columns table are used for in a PostGIS database?

My geography_columns view is empty so I can't see what the purpose of it is.


share|improve this question
Please see this Question and Accepted answer -… – Mapperz Mar 18 '13 at 17:03
up vote 3 down vote accepted

geometry_columns is part of the Simple Features specification for OGC and ISO 19125-2:2004 Standards compliance. geography_columns is a non-Standard variation to support the geography type.


PostGIS follows the Open Geospatial Consortium’s “Simple Features for SQL Specification”

share|improve this answer

Those views (tables in older versions) is there to help client software fast understand what it can expect of the datasets. Most of the information in those views is also in each geometry, like srid, number of dimensions and so on. But it would take a very long time for a client program to scan all the geometries to find that out.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.