What it does
PostgreSQL is an object-relational database system that uses and extends SQL. The project documents capabilities including data types, indexes, constraints, JSON, partitioning, and replication. Teams can install the database server and manage it themselves, or choose an independently operated PostgreSQL service. The official tutorial starts with a running server, creating a database, then using psql to issue SQL, making it possible to learn the client-server workflow with a small project database.
PostgreSQL's first tutorial task is deliberately small: connect to a running server, create a database, and open it from a client. The guide uses createdb mydb followed by psql mydb; these are illustrative documentation examples. From the psql prompt, you can enter SQL interactively. The same database can also be accessed through graphical front ends or application drivers, as the tutorial notes. ### From a learning database to an application
Start with a local or otherwise accessible server and a role allowed to create a database. Keep a small sample schema so you can practice defining tables, inserting rows, and querying them before connecting an application. PostgreSQL's feature pages describe SQL and object-relational capabilities such as constraints, indexing, JSON, extensions, and replication; select features according to the workload rather than enabling every option at once. PostgreSQL is the database engine, not a managed cloud plan. Operating it yourself means arranging installation, access control, backups, upgrades, and capacity for your deployment. The project uses the PostgreSQL License, which it describes as a liberal open-source license similar to BSD or MIT. Hosted PostgreSQL services are separate products with their own pricing and operational limits.
Strengths
- The project combines SQL with a broad set of documented database capabilities, including JSON, indexes, constraints, and replication.
- The official tutorial offers a direct path from database creation to an interactive psql session.
- The PostgreSQL License permits use under a permissive open-source license.
Watch out for
- A self-managed installation leaves server operations, backups, upgrades, and access policy to the operator.
Best for
- Applications that need a general-purpose SQL database under direct operational control
- Learning relational database work by creating a database and using psql to run SQL
Sources
- PostgreSQL project home (Oct 25, 2026)
- About PostgreSQL (Oct 25, 2026)
- PostgreSQL tutorial: Creating a Database (Oct 25, 2026)
- PostgreSQL tutorial: Accessing a Database (Oct 25, 2026)
- PostgreSQL License (Oct 25, 2026)
- PostgreSQL source repository (Oct 25, 2026)