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

2 votes188 views1 answer
What is deffrent between apt and apt-get
Shell/Bash
0 vote151 views2 answers
Sed remove empty lines
Shell/Bash
2 votes239 views1 answer
Sshpass mac os x brew
Shell/Bash
1 vote193 views1 answer
How to store float values in shell script
Shell/Bash
-1 vote193 views1 answer
Remove all iptables rules
Shell/Bash
1 vote196 views1 answer
Linux ram drive
Shell/Bash
1 vote178 views1 answer
Elevated privileges windows 10
Shell/Bash
15 votes200 views6 answers
Switch to remote branch git
Shell/Bash
1 vote168 views1 answer
Bash add or subtract one column from another
Shell/Bash
0 vote194 views2 answers
Find exclude directories
Shell/Bash