Start using PostgreSQL
What PostgreSQL is
Understand the PostgreSQL client-server model and the PostgreSQL 18 baseline used throughout this course.
8 minute lesson
~~~
PostgreSQL is a relational database server. The server owns the data files, manages concurrent work, and listens for connections from applications and tools.
This course targets PostgreSQL 18. SQL is the language you send to PostgreSQL. psql is one command-line client that sends it.
One server can hold several databases. A connection enters one database as one role, then works with tables and other objects inside that database.
Lesson completed