...
If everything goes fine, you can check your created database by \l command as below:
| Code Block |
|---|
\l |
The result will be like:
| Code Block |
|---|
mydb | postgres | UTF8 | en_US.UTF-8 | C | =Tc/postgres +
| | | | | postgres=CTc/postgres +
| | | | | myuser=CTc/postgres
postgres | postgres | SQL_ASCII | en_US.UTF-8 | C |
template0 | postgres | SQL_ASCII | en_US.UTF-8 | C | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | C | |
...