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 vote164 views2 answers
Add colum in sql
SQL
11 votes254 views1 answer
Oracle insert from select
SQL
0 vote182 views1 answer
Install sql server in ubuntu 20.04
SQL
3 votes190 views1 answer
Oracle undo tablespace schema
SQL
0 vote126 views1 answer
Check id exist or not in sql
SQL
12 votes148 views5 answers
Sql merge
SQL
0 vote165 views1 answer
How to declare variable date in mysql
SQL
19 votes164 views4 answers
Rename database in sql
SQL
0 vote178 views1 answer
Function sum(text) does not exist postgres
SQL
1 vote168 views1 answer
Rows to comma separated values in mssql
SQL