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 votes340 views2 answers
MySql FULL OUTER JOIN
SQL
1 vote306 views1 answer
Mysql select row max date
SQL
0 vote344 views1 answer
TSQL Find csv file in folder
SQL
9 votes259 views2 answers
Oracle all tables in schema
SQL
6 votes275 views1 answer
Sql insert values into table
SQL
15 votes287 views2 answers
Select where duplicate mysql
SQL
15 votes284 views5 answers
If null mysql
SQL
0 vote289 views1 answer
Uncheck constraints and delete from table
SQL
-1 vote259 views1 answer
Mysql coalesce
SQL
0 vote288 views1 answer
Multiple replace value mssql
SQL