3

I do not understand the difference between PostGIS and PostgreSQL.

What is the difference in detail between them?

0

2 Answers 2

16

PostgreSQL is an object-relational database management system. In other words, it is software that allows you to manage databases. By default, it does not manage spatial data. In order to work with spatial data it is necessary to install a module named PostGIS. Therefore PostGIS is the module of PostgreSQL that allows you to work in GIS.

0
5

As one might expect, the PostGIS website itself offers a multitude of explanations. Emphases below are mine.

https://postgis.net/ says

Spatial and Geographic Objects for PostgreSQL

and

PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL.

https://postgis.net/docs/manual-2.4/ says

PostGIS is an extension to the PostgreSQL object-relational database system which allows GIS (Geographic Information Systems) objects to be stored in the database. PostGIS includes support for GiST-based R-Tree spatial indexes, and functions for analysis and processing of GIS objects.

0

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