Psql create database

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;

Similar codes

0 vote144 views2 answers
Sql update top 100
SQL
2 votes167 views3 answers
Sql server: how to concatenate column data using comma
SQL
2 votes158 views1 answer
Guid to string sql
SQL
0 vote150 views1 answer
How to create a new shema using query languaage
SQL
0 vote157 views1 answer
Postgresql inheritance
SQL
0 vote409 views1 answer
Create pl/sql stored procedure
SQL
0 vote142 views1 answer
Mysql query to check record exists in database table or not
SQL
3 votes266 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote152 views1 answer
How to add unique key constraint in mysql
SQL
4 votes208 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL