To create a new database in PostgreSQL, you can use the CREATE DATABASE
statement. Here is the basic syntax for this statement:
1 |
CREATE DATABASE database_name; |
Replace database_name
with the name of the database that you want to create. For example, to create a database named my_database
, you would use the following statement:
1 |
CREATE DATABASE my_database; |
This will create a new database with the specified name. You can then connect to the database and start creating tables, indexes, and other database objects within it.