Create database postgres

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;

Source: grepper.com

Postgres create database

sudo su - postgres
psql -c "create database demo"

Source: grepper.com

Similar codes

0 vote109 views1 answer
Rabbitmq service not starting
SQL
0 vote190 views1 answer
Mysql disable triggers
SQL
3 votes123 views3 answers
Start postgresql ubuntu
SQL
13 votes124 views1 answer
Sql join 3 tables on id
SQL
10 votes112 views3 answers
Insert into auto increment mysql
SQL
0 vote114 views1 answer
Sql get guid
SQL
2 votes67 views2 answers
Mysql get last character of string
SQL
0 vote115 views1 answer
Oracle current session details
SQL
0 vote117 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote123 views1 answer
Sql query tags
SQL