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

2 votes197 views1 answer
Oracle Column Names of a table
SQL
0 vote169 views2 answers
Create-toys-table-with-toy_name-column
SQL
1 vote151 views1 answer
Return size of tables in mysql
SQL
1 vote165 views2 answers
Create a unqie constraint mysql
SQL
0 vote144 views2 answers
Default constraint in ms sql
SQL
0 vote140 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote160 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote194 views5 answers
Right join
SQL
0 vote160 views2 answers
Dbms interview questions
SQL
1 vote171 views1 answer
Mysql update inner
SQL