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 vote144 views1 answer
How to make QtWebengine have smooth scrolling
Shell/Bash
4 votes146 views1 answer
Git fetch prune
Shell/Bash
0 vote137 views1 answer
How to host a file within a folder in github
Shell/Bash
0 vote157 views1 answer
Bash list files for user
Shell/Bash
36 votes152 views4 answers
Git delete stash
Shell/Bash
1 vote134 views1 answer
Listener kali linux
Shell/Bash
0 vote98 views2 answers
Raspberry pi ubuntu config
Shell/Bash
3 votes138 views7 answers
Pm2 install
Shell/Bash
8 votes158 views1 answer
Enable WSL on windows
Shell/Bash
3 votes129 views2 answers
Hot to remove .env from git
Shell/Bash