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

-1 vote301 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
16 votes286 views3 answers
Jwt secret key generator laravel
SQL
3 votes295 views1 answer
Mysql insert on dupèlicate
SQL
2 votes261 views3 answers
Application.properties spring boot mysql
SQL
0 vote304 views1 answer
Python sqlalchemy connection show server
SQL
0 vote304 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote247 views1 answer
Get number of table colums in sql query
SQL
1 vote256 views1 answer
Postgresql convert text to float
SQL
4 votes285 views1 answer
Find tables with column name in sql
SQL
0 vote270 views1 answer
How to put is null in where in clause
SQL