Rename database

sql

ALTER DATABASE appdb RENAME TO appdb_prod;

Explanation

Cannot rename the currently connected database.

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 new database in the cluster.

Open In sheetsqlsame section

Create a database with explicit owner and template.

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