🐘 PostgreSQL
Beginner
What is a database in PostgreSQL?
Answer
In PostgreSQL, a database is an isolated namespace that contains schemas, tables, views, functions, sequences, and other objects. A single PostgreSQL server instance (cluster) can host multiple databases. Each database is completely isolated — you cannot directly join tables from different databases. Databases are created with CREATE DATABASE dbname; and listed with \l in psql or SELECT datname FROM pg_database;. The default databases created during installation are postgres (admin default), template0 (pristine template), and template1 (customizable template used when creating new databases).