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

0 vote130 views1 answer
Uninstalling audacity on linux
Shell/Bash
17 votes152 views3 answers
How to uncommit the last commit in git
Shell/Bash
0 vote170 views2 answers
Download office 365 for ubuntu
Shell/Bash
0 vote149 views1 answer
Download project from github
Shell/Bash
15 votes145 views6 answers
Kubectl install on ubuntu
Shell/Bash
4 votes136 views1 answer
Remove letter in string bash
Shell/Bash
0 vote141 views2 answers
Update arch on terminal
Shell/Bash
3 votes135 views3 answers
Sqlite install windows
Shell/Bash
2 votes143 views1 answer
Git clone ssh key
Shell/Bash
3 votes199 views2 answers
Sass : The term 'sass' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
Shell/Bash