...
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 | |
You can also do above directly make psql commands one by one by adding -c parameter:
| Code Block |
|---|
sudo -u postgres psql -c "CREATE USER your_user_id with password 'your_password' superuser;" |
...