Tutorials › PostgreSQL Essentials › Creating Databases

Creating Databases

4 min read

PostgreSQL organizes data into databases. Use CREATE DATABASE to create one and \c dbname in psql to switch to it. Schemas provide further namespace separation. Each application should have its own dedicated database.

Creating Databases

CREATE DATABASE shop;
CREATE DATABASE analytics OWNER alice ENCODING 'UTF8';
DROP DATABASE shop;       -- delete permanently
ALTER DATABASE shop RENAME TO store;

Template databases

Every new DB clones from template1 by default. You can create custom templates for consistent defaults.

← Connecting with psql Next: Data Types →

Quick Access

Creating Databases

Creating Databases

Template databases