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

13 votes211 views1 answer
Views in sql
SQL
18 votes226 views3 answers
Mysql add column default value
SQL
0 vote228 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote215 views8 answers
Convert sql query to linq online
SQL
2 votes189 views1 answer
Sqlplus clear screen
SQL
2 votes203 views1 answer
Oracle calculated column
SQL
0 vote267 views1 answer
Convert rows into columns in oracle
SQL
3 votes230 views2 answers
Sql not contains
SQL
1 vote252 views1 answer
Set statiscis on in sql server
SQL
0 vote215 views3 answers
Duplicate row mysql
SQL