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

2 votes150 views2 answers
How to check database username and password in postgresql
SQL
1 vote151 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
0 vote166 views1 answer
Oracle c# multiple update sql
SQL
2 votes160 views1 answer
No data found oracle
SQL
0 vote185 views1 answer
Sql field equals multiple values
SQL
0 vote162 views1 answer
Mysql pad zeros
SQL
1 vote159 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote170 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote171 views1 answer
Rabbitmq ui not working
SQL
2 votes157 views2 answers
Created at and updated at in mysql
SQL