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

21 votes244 views4 answers
Git reset hard
Shell/Bash
2 votes222 views2 answers
Git empty stash
Shell/Bash
10 votes214 views3 answers
Git remove file from commit
Shell/Bash
0 vote247 views1 answer
How to install ros package
Shell/Bash
10 votes252 views4 answers
Git revert uncommitted changes
Shell/Bash
0 vote229 views1 answer
Check if the syntax correct ubuntu
Shell/Bash
0 vote265 views4 answers
Brew1
Shell/Bash
1 vote239 views1 answer
Windows XpdfReader 'pdftotext' does not appear to be installed
Shell/Bash
0 vote330 views2 answers
Batch file to install multiple programs
Shell/Bash
8 votes240 views1 answer
Yarn 2 upgrade all packages
Shell/Bash