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

2 votes294 views1 answer
Query any digits record
SQL
5 votes258 views1 answer
Postgres upsert
SQL
10 votes303 views3 answers
Sql select between two dates
SQL
5 votes302 views3 answers
Mysql remove unique constraint
SQL
0 vote248 views1 answer
Query for maximum salary
SQL
0 vote295 views1 answer
Multiple left join mysql
SQL
6 votes299 views3 answers
Update with inner join postgres
SQL
3 votes278 views1 answer
Oracle user quota unlimited
SQL
0 vote299 views1 answer
Function plsql
SQL
0 vote290 views1 answer
Trigger stock phpmyadmin output message
SQL