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

0 vote147 views1 answer
Create domain sql
SQL
1 vote165 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote145 views1 answer
Copying query result to excel
SQL
13 votes147 views4 answers
What is sql
SQL
2 votes153 views2 answers
Create empty table from existing table
SQL
0 vote144 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote135 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
1 vote174 views2 answers
Install sql server management studio ubuntu
SQL
2 votes140 views2 answers
Sqlalchemy filter or
SQL
1 vote143 views1 answer
Spark sql concatenate string and int
SQL