Create database

sql

CREATE DATABASE appdb;

Explanation

Databases are cluster-level objects and must be created from another existing database such as `postgres`.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Database and Role Lifecycle

Create a database with explicit owner and template.

Open In sheetsqlsame section

Rename an existing database.

Open In sheetsqlsame section

Delete a database permanently.

Open In sheetsqlsame section

Create a role that can log in.

Open In sheetsqlsame section

Create a role with explicit capability flags.

Open In sheetsqlsame section

Update a role password.

Open In sheetsqlsame section