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

1 vote308 views1 answer
How to transfer data using ssh
Shell/Bash
0 vote324 views2 answers
Video to gif ffmpeg
Shell/Bash
0 vote316 views1 answer
How to push the code in a perticular branch
Shell/Bash
0 vote344 views1 answer
Linux show alias function
Shell/Bash
4 votes338 views1 answer
Format pendrive linux
Shell/Bash
6 votes324 views2 answers
Post with httpie
Shell/Bash
0 vote297 views1 answer
Flush ip windows 10
Shell/Bash
3 votes333 views1 answer
How to download youtube video from command line
Shell/Bash
0 vote374 views1 answer
App store allow from anywhere
Shell/Bash
5 votes316 views1 answer
Bash hide command output
Shell/Bash