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

5 votes147 views1 answer
Mysql count newlines in field
SQL
0 vote147 views1 answer
Postgresql custom order by
SQL
1 vote153 views1 answer
Oracle insert multiple rows into same table
SQL
0 vote144 views1 answer
Oracle concat datetime
SQL
0 vote124 views1 answer
Full syntax inner join
SQL
0 vote134 views1 answer
Postgres regex word boundary
SQL
0 vote166 views1 answer
Cannot start database server xampp mac os
SQL
5 votes158 views2 answers
Get columns number sql
SQL
0 vote147 views1 answer
Sql server roles and users
SQL
0 vote148 views1 answer
Set engine to innodb
SQL