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 vote184 views1 answer
Name '_mysql' is not defined
SQL
0 vote224 views1 answer
Google cloud sql postgres url example
SQL
10 votes256 views4 answers
Mysql one week ago
SQL
0 vote190 views1 answer
Data structures in sql
SQL
1 vote196 views6 answers
In sql
SQL
7 votes196 views4 answers
How to reset the identity column in sql server
SQL
0 vote194 views3 answers
Create and attach user to a postgresql database
SQL
7 votes193 views1 answer
Minecraft forge server host
SQL
0 vote187 views1 answer
Psql check if value in array
SQL
0 vote207 views1 answer
Power bi union columns
SQL