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 vote327 views1 answer
Mysql join same table multiple times group by
SQL
1 vote335 views1 answer
Error code 1175 mysql fix
SQL
0 vote366 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
1 vote292 views1 answer
Database run
SQL
0 vote326 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
1 vote319 views1 answer
Minus vs intersect in sql
SQL
0 vote314 views1 answer
Mysql select where text contains
SQL
2 votes325 views1 answer
Oracle convert run_duration to number
SQL
0 vote325 views1 answer
Alter table add foreign key mariadb example
SQL
1 vote322 views2 answers
Sql multiline comment
SQL