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

27 votes251 views3 answers
Mysql delete row
SQL
2 votes129 views1 answer
Q operator in oracle
SQL
0 vote131 views1 answer
Sql add calculated column
SQL
7 votes146 views1 answer
Sql limit decimal places
SQL
0 vote242 views1 answer
Sql server query all database objects
SQL
22 votes126 views3 answers
Join three tables sql
SQL
0 vote137 views2 answers
Find lowest number in sql
SQL
1 vote128 views1 answer
Temp table vs variable table in sql server
SQL
1 vote119 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
1 vote126 views1 answer
Mamp mysql path mac
SQL