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 vote177 views1 answer
Postgres call view
SQL
1 vote191 views1 answer
Select not matching data from two tables
SQL
0 vote174 views1 answer
Postgres create database if not exists
SQL
10 votes186 views4 answers
Primary key sql
SQL
2 votes194 views1 answer
Sql string_agg
SQL
0 vote237 views5 answers
Select concat alter table mysql
SQL
0 vote180 views1 answer
Sql server list user permissions
SQL
0 vote196 views1 answer
Postgresql array to rows
SQL
0 vote182 views1 answer
Mysql user set plugin
SQL
8 votes179 views1 answer
Oracle add months to sysdate
SQL