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 vote104 views1 answer
Postgres drop type
SQL
1 vote106 views1 answer
Sql try catch
SQL
0 vote98 views1 answer
Get all employees if name ends with in sql
SQL
0 vote108 views1 answer
Set mysql socket file docker windows
SQL
0 vote101 views1 answer
Groupby error in mysql
SQL
11 votes225 views2 answers
Import mysql dump command line windows
SQL
8 votes126 views1 answer
My sql version
SQL
0 vote95 views2 answers
Sql last updated
SQL
3 votes97 views2 answers
To_char oracle
SQL
3 votes54 views1 answer
How to get list of synonyms in oracle
SQL