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 vote106 views1 answer
Sql find leading space
SQL
0 vote127 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
1 vote111 views1 answer
Sql server locks
SQL
0 vote111 views1 answer
Initcap in mysql
SQL
0 vote175 views4 answers
Stored procedure sql
SQL
1 vote133 views1 answer
Sql server if exists update else insert
SQL
6 votes106 views2 answers
Mysql convert timestamp to date
SQL
0 vote135 views3 answers
Get count of null in column sql
SQL
2 votes114 views1 answer
Pdo mysql insert
SQL
0 vote115 views1 answer
Get server date mysql
SQL