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 vote356 views1 answer
Bash multiply float
Shell/Bash
0 vote317 views1 answer
Valgrind memory leak
Shell/Bash
0 vote349 views1 answer
Add pwd to path linux
Shell/Bash
0 vote320 views1 answer
Git use stash on another computer
Shell/Bash
0 vote357 views2 answers
Brew install php 7.3
Shell/Bash
18 votes332 views4 answers
How to undo git clean -fd command
Shell/Bash
17 votes337 views3 answers
Remove docker volume
Shell/Bash
0 vote334 views1 answer
Ubuntu power saving
Shell/Bash
0 vote353 views1 answer
Ubuntu sha256
Shell/Bash
0 vote327 views1 answer
Unistall filezilla ubuntu
Shell/Bash