Postgre create user

#!/usr/bin/env bash
# to execute, open a terminal in directory and run chmod +x <filename>.sh

user="{user name}"
database="{database name}"
args="--host=localhost --dbname=$database --username=$user"

echo -e "Creating user $user.....\n"
sudo -u postgres createuser --createdb --pwprompt $user
echo -e "User Created!\n"

echo -e "Creating database $database.....\n"
sudo -u postgres createdb --owner=$user $database
echo -e "Database Created!\n"
echo -e "Restarting server and starting psql....\n"
sudo service postgresql restart

psql $args

Similar codes

1 vote260 views1 answer
Error cannot find module 'browser-sync' gulp
Shell/Bash
2 votes254 views1 answer
Check ssd or hdd linux
Shell/Bash
0 vote260 views1 answer
Install activitywatch ubunut
Shell/Bash
1 vote276 views1 answer
Install netstat ubuntu
Shell/Bash
2 votes260 views1 answer
Ionic cordova sign apk
Shell/Bash
10 votes275 views2 answers
Ubuntu clear dns cache
Shell/Bash
0 vote266 views2 answers
Kubectl list context
Shell/Bash
35 votes276 views2 answers
Update node version debian
Shell/Bash
0 vote249 views1 answer
How to check version of web3
Shell/Bash
0 vote253 views1 answer
Run apache xampp
Shell/Bash