What is PostgreSQL?
PostgreSQL is a free, open-source object-relational database system. Often called 'Postgres', it's known for its strong standards compliance, ACID transactions, extensibility, and advanced features like JSON support, full-text search, and geographic data handling with PostGIS.