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 vote187 views3 answers
How to uninstall oh my zsh
Shell/Bash
0 vote164 views1 answer
Install java 16 ubuntu
Shell/Bash
32 votes167 views1 answer
Install pip ubuntu 20.04 using snap
Shell/Bash
0 vote174 views1 answer
Telnet in shell script
Shell/Bash
0 vote170 views1 answer
Slow scaninng
Shell/Bash
0 vote180 views1 answer
Setup git config for multiple accounts
Shell/Bash
8 votes162 views1 answer
How to uninstall kali linux
Shell/Bash
7 votes182 views2 answers
Ubuntu get your ip address from terminal\
Shell/Bash
1 vote167 views1 answer
How to change the icon of a python exe file
Shell/Bash
6 votes172 views3 answers
Git graph command
Shell/Bash