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

3 votes141 views2 answers
Git find when file was deleted
Shell/Bash
25 votes147 views4 answers
Command line size of directory
Shell/Bash
8 votes155 views6 answers
Unable to acquire the dpkg frontend lock (/var/lib/dpkg/lock-frontend), is another process using it?
Shell/Bash
0 vote150 views2 answers
Powershell get ip address
Shell/Bash
2 votes149 views1 answer
Grep remove branches
Shell/Bash
-1 vote160 views1 answer
Snap linux
Shell/Bash
58 votes210 views6 answers
Install pip3
Shell/Bash
0 vote148 views1 answer
Ubuntu history to file without line number
Shell/Bash
0 vote138 views1 answer
Read not working in shell script
Shell/Bash
0 vote141 views1 answer
Filter in powershell Win32_NTEventlogFile
Shell/Bash