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 vote303 views1 answer
Lister les index d'une table oracle
SQL
0 vote316 views1 answer
Sql track modification
SQL
1 vote283 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
2 votes314 views1 answer
Mysql find tables with name
SQL
0 vote316 views1 answer
Sql query to check if column contains alphabets
SQL
0 vote316 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
1 vote336 views3 answers
Rename table snowflake
SQL
3 votes344 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote321 views1 answer
Mysql find db contarint
SQL
1 vote342 views2 answers
Remove space in mysql
SQL