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 vote207 views1 answer
Postgres where
SQL
10 votes172 views1 answer
Oracle view dependencies
SQL
1 vote212 views1 answer
Sql server locks
SQL
0 vote237 views4 answers
Sql rownum
SQL
0 vote214 views1 answer
Plsql check for string in numeric
SQL
0 vote237 views1 answer
Postgresql print sessions using the database
SQL
2 votes221 views4 answers
Mysql get all tables row count
SQL
0 vote214 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote219 views1 answer
Sql get year from datetime field
SQL
0 vote210 views3 answers
Mysql keyword search
SQL