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

9 votes134 views2 answers
Mysql change value
SQL
1 vote128 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote155 views1 answer
Java spring boot connect to sql server
SQL
10 votes176 views4 answers
Sql server pagination
SQL
-1 vote139 views1 answer
How to check table exists or not in postgresql
SQL
1 vote140 views1 answer
Simple project for database
SQL
10 votes144 views2 answers
Sql rtrim
SQL
0 vote127 views1 answer
Group by 15 minute interval sql server
SQL
0 vote149 views1 answer
Create table using the clause with as
SQL
1 vote160 views2 answers
Full join
SQL