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

15 votes236 views3 answers
Ionic capacitor v3 run android livereload
Shell/Bash
21 votes230 views4 answers
Pyautogui install
Shell/Bash
0 vote243 views1 answer
Install vert manager linux
Shell/Bash
7 votes281 views2 answers
Download torrent on ubuntu
Shell/Bash
3 votes247 views3 answers
Unix to datetime
Shell/Bash
0 vote236 views1 answer
Stop gnix
Shell/Bash
2 votes248 views2 answers
Cannot connect to the Docker daemon at tcp://localhost:2375. Is the docker daemon running?
Shell/Bash
1 vote217 views1 answer
How to change directory if folder name have space
Shell/Bash
77 votes345 views6 answers
Zip files linux
Shell/Bash
0 vote268 views1 answer
Hint: Waiting for your editor to close the file... need to run as root or suid
Shell/Bash