Cheat Sheet logoCheat Sheet Today
PostgreSQL Administration Cheat Sheet/Create database from shell

Create a database using the `createdb` utility.

Back to sheetBrowse commands
Sign in to save
Section: Database Administration Utilities

Create database from shell

bash
bash
createdb -h localhost -U postgres appdb
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

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

Compare commandsView fixes

Related commands

Same sheet · prioritizing Database Administration Utilities
Drop database from shell
Drop a database using the `dropdb` utility.
OpenIn sheetbashsame section
Create role from shell
Interactively create a new role.
OpenIn sheetbashsame section
Drop role from shell
Remove a role using the command-line utility.
OpenIn sheetbashsame section
Reindex database
Rebuild indexes in a database.
OpenIn sheetbashsame section
Vacuum and analyze
Run vacuum/analyze from the shell.
OpenIn sheetbashsame section
Physically reorder table
Rewrite a table using an index order.
OpenIn sheetsqlsame section