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

0 vote187 views1 answer
Powershell check if user is admin
Shell/Bash
1 vote194 views1 answer
Install mongodb on manjaro linux
Shell/Bash
0 vote171 views1 answer
Libssl-dev install on ubuntu
Shell/Bash
1 vote183 views1 answer
Bash cd or make dir if not exists
Shell/Bash
5 votes178 views3 answers
[!] Android Studio (not installed) flutter
Shell/Bash
0 vote181 views1 answer
How to show which kerne version is intalled on the system linux
Shell/Bash
0 vote170 views2 answers
Vue 3 qr code reader
Shell/Bash
8 votes133 views3 answers
Ubuntu remove package
Shell/Bash
18 votes228 views6 answers
Git checkout remote branch
Shell/Bash
0 vote187 views1 answer
Nohup run node/npm
Shell/Bash