In PostgreSQL CREATE DATABASE statement is used for creating new database in server. Login to PostgreSQL database command prompt using command ‘sudo -u postgres psql‘ from terminal.
Syntax :-
CREATE DATABASE database_name;
Example :-
Login to your PostgreSQL server using command line. You will get PostgreSQL database prompt like postgres=# . Now use CREATE DATABASE statement to create database.
postgres=# CREATE DATABASEmydb ;
If everything goes successfully, you will get output like “CREATE DATABASE“.
To confirm that database is create use l or list command from database command prompt to list all databases.
postgres=# list List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+----------+----------+---------+-------+-----------------------mydb | postgres | UTF8 | en_IN | en_IN | postgres | postgres | UTF8 | en_IN | en_IN | template0 | postgres | UTF8 | en_IN | en_IN | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | en_IN | en_IN | =c/postgres + | | | | | postgres=CTc/postgres (4 rows)