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

1 vote58 views1 answer
Sample clause in sql
SQL
0 vote52 views1 answer
Mysql select row with min date
SQL
1 vote49 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
-1 vote55 views1 answer
Sql add column bit
SQL
1 vote55 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
0 vote55 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote51 views1 answer
Install squirrel sql ubuntu
SQL
0 vote48 views1 answer
Populate db from command line postgres
SQL
0 vote49 views1 answer
Sum value by month sql
SQL
0 vote75 views1 answer
Cube oracle
SQL