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 vote162 views2 answers
Uninstall postgres brew
Shell/Bash
15 votes98 views8 answers
React bootstrap
Shell/Bash
5 votes105 views3 answers
Foreach powershell
Shell/Bash
0 vote109 views1 answer
How to uninstall slack in ubuntu 20.04
Shell/Bash
8 votes148 views2 answers
Linux screen kill attached session
Shell/Bash
-1 vote100 views2 answers
Git clone with branch name command
Shell/Bash
1 vote94 views2 answers
Pacman command on arch
Shell/Bash
0 vote110 views1 answer
Multiple delimiter awk
Shell/Bash
0 vote92 views1 answer
Docker run gitlab runner
Shell/Bash
0 vote115 views1 answer
Curl cookie-jar
Shell/Bash