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

3 votes150 views1 answer
Oracle transaction commit rollback example
SQL
0 vote157 views1 answer
Check if has alpha characters sql
SQL
0 vote144 views2 answers
Sql last updated
SQL
2 votes143 views2 answers
Mysql all columns
SQL
4 votes152 views3 answers
Postgres set default value
SQL
1 vote199 views2 answers
Mysql SELECT
SQL
6 votes156 views1 answer
Postgres get size of database
SQL
0 vote201 views1 answer
Parent and child link in mysql
SQL
0 vote155 views1 answer
Select even number id data from table
SQL
0 vote148 views1 answer
Sql create text column limited values
SQL