Dropped geometry_columns and geography_columns tables

What is the difference between geography and geometry in PostgreSQL?

Geometry, where it assumes all of your data lives on a Cartesian plane (like a map projection); Geography, where it assumes that your data is made up of points on the earth’s surface, as specified by latitudes and longitudes.
 

What is geometric vs geographic data?

So Geographical Data is simply Longitude and Latitude. Geometric Data : Geometry deals with mathematical properties (topology, metric, order). By these properties we could analyze the data.
 

What is geometry vs geography type?

Geometry : Stores data based on a flat (Euclidean) coordinate system. The data type is often used to store the X and Y coordinates that represent lines, points, and polygons in two-dimensional spaces. Geography : Stores data based on a round-earth coordinate system.