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

2 votes135 views2 answers
Command to delete all files in a directory
Shell/Bash
0 vote160 views1 answer
Exit branch git
Shell/Bash
0 vote163 views1 answer
How to get server ip address centos
Shell/Bash
2 votes162 views1 answer
Bash if set variable
Shell/Bash
0 vote156 views1 answer
Powershell delete columns in multiple csv files
Shell/Bash
1 vote171 views1 answer
How to install cargo packages
Shell/Bash
0 vote155 views1 answer
Awk '(split by space)
Shell/Bash
0 vote162 views1 answer
Perl search if variable contains word
Shell/Bash
0 vote182 views1 answer
Fatal: 'origin/main-dev' is not a commit and a branch 'base' cannot be created from it
Shell/Bash
0 vote188 views1 answer
Grep until third match
Shell/Bash