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 vote290 views3 answers
Get count of null in column sql
SQL
2 votes196 views2 answers
Useradd postgres
SQL
2 votes206 views1 answer
Use cases condition in sql query laravel
SQL
7 votes190 views3 answers
Sql get last inserted row
SQL
0 vote194 views1 answer
How to reset the database value in SQL server
SQL
0 vote214 views3 answers
Mysql regex replace
SQL
-1 vote217 views1 answer
Mysql delete duplicate rows except one
SQL
2 votes192 views2 answers
Sql first character
SQL
0 vote200 views1 answer
How to query all tables mysql at the same time
SQL
0 vote198 views3 answers
Mysql delete if not in another table
SQL