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 vote220 views1 answer
Mysql get hour from datetime
SQL
27 votes217 views3 answers
Mysql show tables in database
SQL
0 vote181 views3 answers
Average salary in sql
SQL
10 votes180 views3 answers
Sql limit results
SQL
5 votes184 views4 answers
Describe table postgres
SQL
0 vote207 views2 answers
Mysql dump structure only
SQL
0 vote367 views1 answer
Install mysql on bash
SQL
0 vote258 views1 answer
Best sql collation
SQL
0 vote168 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
0 vote200 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL