Can anyone tell me what is the purpose of
geography_columns view and
geometry_columns view in a PostGIS database?
geography_columns view is empty so I can't see what the purpose of it is.
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
PostGIS follows the Open Geospatial Consortium’s “Simple Features for SQL Specification”
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.