What is PostgreSQL? Definition and explanations

PostgreSQL is an open-source relational database management system, known for its adherence to the SQL standard and its transactional reliability. It also handles JSON, full-text search, geographic data through PostGIS and, more recently, vectors through pgvector. That versatility often removes the need to add a second, specialised database to the architecture.

We have a full page on this subject, with the detail, the use cases and how we approach it.