Tutorials › PostgreSQL Essentials › What is PostgreSQL?

What is PostgreSQL?

5 min read Quiz at the end

PostgreSQL is a powerful open-source relational database known for reliability and advanced features. It supports complex queries, JSONB, full-text search, and custom data types. Trusted by Instagram, Spotify, and Uber.

What is PostgreSQL?

PostgreSQL (Postgres) is a powerful, open-source object-relational database system with over 35 years of active development. It is known for reliability, feature robustness, and performance.

Key features

ACID-compliant transactions
Supports JSON, XML, and arrays natively
Advanced indexing (B-tree, Hash, GIN, GiST)
Extensible with custom functions and data types

Who uses it?

Instagram, Spotify, GitHub, and many Fortune 500 companies rely on PostgreSQL for mission-critical data.

← Back to overview Next: Installing PostgreSQL →

Topic Quiz · 5 questions

Test your understanding before moving on

1. What does ACID stand for in databases?

💡 ACID ensures reliable database transactions: Atomicity, Consistency, Isolation, Durability.

2. Which type of database is PostgreSQL?

💡 PostgreSQL is an object-relational database management system (ORDBMS).

3. Which company created PostgreSQL?

💡 PostgreSQL originated at UC Berkeley from the POSTGRES project.

4. Which data format does PostgreSQL support natively?

💡 PostgreSQL has native JSONB support for storing and querying JSON data.

5. What does "open-source" mean for PostgreSQL?

💡 PostgreSQL is fully open-source — the source code is freely available and modifiable.

Quick Access

What is PostgreSQL?