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 vote112 views1 answer
Trigger stock phpmyadmin
SQL
0 vote115 views1 answer
Hallo
SQL
1 vote86 views1 answer
Update mysql centos
SQL
2 votes122 views2 answers
Mysql date range
SQL
0 vote126 views1 answer
Get total and distict row diff in sql
SQL
0 vote92 views1 answer
Sql clear table
SQL
0 vote105 views1 answer
Sql remove last 2 digit
SQL
1 vote99 views1 answer
Mysql sort by date column
SQL
1 vote106 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
0 vote105 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL