Psql create database

Create postgres database

sudo -u postgres psql
postgres=# create database mydb;
postgres=# create user myuser with encrypted password 'mypass';
postgres=# grant all privileges on database mydb to myuser;

Source: medium.com

Create database postgres

createdb -h localhost -p 5432 -U postgres testdb
password ******

Source: tutorialspoint.com

Psql create database

# To create a new PostgreSQL database while using psql
CREATE DATABASE nameOfDatabase;

Similar codes

0 vote187 views1 answer
SQL Cut part string
SQL
1 vote164 views1 answer
Events mysql
SQL
0 vote163 views1 answer
Oracle flush Shared Pool
SQL
1 vote164 views1 answer
Type int in mysql maxlenght
SQL
0 vote160 views1 answer
Porcentaje sql
SQL
0 vote189 views1 answer
Sql decimal to 2 places
SQL
0 vote177 views1 answer
Oracle insert single quote in string
SQL
0 vote176 views1 answer
Sql server current time without date
SQL
0 vote172 views1 answer
Oracle last connexion
SQL
0 vote149 views1 answer
Access refused mysql xampp server
SQL