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

6 votes364 views2 answers
If not exists insert sql
SQL
3 votes356 views1 answer
How to uninstall microsoft sql server
SQL
0 vote437 views1 answer
Sql datum formatieren
SQL
1 vote334 views1 answer
Foreign key in oracle sql developer
SQL
7 votes391 views2 answers
Mysql check db size
SQL
9 votes368 views1 answer
Mysql check date range
SQL
5 votes375 views1 answer
Mysql count newlines in field
SQL
4 votes312 views1 answer
Install postgres 12 on ubuntu
SQL
1 vote392 views1 answer
Sql server delete top 1000
SQL
25 votes406 views6 answers
Import database mysql command line
SQL