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 vote283 views1 answer
Print mysql
SQL
0 vote281 views1 answer
Oracle list user locked
SQL
0 vote273 views2 answers
SQL FROM
SQL
0 vote275 views1 answer
Get null value in sql
SQL
0 vote264 views1 answer
Use between operator in mysql
SQL
6 votes317 views5 answers
Oracle list tablespaces
SQL
10 votes273 views4 answers
Inner join in update query mysql
SQL
4 votes276 views2 answers
Postgres update single column
SQL
15 votes272 views4 answers
Sql update from select
SQL
0 vote285 views1 answer
Sql pad left 0
SQL