Create database postgres

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;

Source: grepper.com

Postgres create database

sudo su - postgres
psql -c "create database demo"

Source: grepper.com

Similar codes

0 vote202 views1 answer
How many columns can be used for creating index?
SQL
1 vote208 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote211 views1 answer
Psql datestyle
SQL
2 votes250 views1 answer
Oracle Column Names of a table
SQL
0 vote266 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote309 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote203 views1 answer
Alasql delete column
SQL
0 vote226 views1 answer
Tsql pad left
SQL
-1 vote235 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
6 votes272 views3 answers
Mysql change auto_increment start value
SQL