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

4 votes122 views1 answer
T-sql get duplicate rows
SQL
0 vote109 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
1 vote113 views1 answer
SQL: merging multiple row data in string
SQL
0 vote134 views1 answer
Oracle create package specification
SQL
20 votes108 views3 answers
SQL query rename table
SQL
0 vote105 views1 answer
Opensuse start MySQL
SQL
0 vote111 views1 answer
Create column that already exists mysql
SQL
0 vote118 views1 answer
Laravel migration sql dump
SQL
1 vote96 views2 answers
Mssql show database size
SQL
-1 vote102 views2 answers
Sql convert date to string yyyy-mm-dd
SQL