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

14 votes364 views4 answers
Microsoft team ubuntu
Shell/Bash
0 vote299 views1 answer
Install youtube-dl on ubuntu 20.04
Shell/Bash
2 votes277 views1 answer
Linux redirect output to file
Shell/Bash
4 votes340 views2 answers
How to install sublime text arch linux
Shell/Bash
0 vote327 views1 answer
Start cpu scheduler on ubuntu terminal
Shell/Bash
2 votes310 views2 answers
How to uninstall heroku cli
Shell/Bash
0 vote365 views2 answers
Install kvm kali
Shell/Bash
1 vote313 views1 answer
Libpng12.so.0 ubuntu 18.04
Shell/Bash
0 vote323 views1 answer
How do I push a repo that says allready exists
Shell/Bash
0 vote314 views1 answer
How to create a shortcut in a batch file
Shell/Bash