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 vote173 views1 answer
Github how to remove changes
Shell/Bash
0 vote162 views1 answer
Ubuntu check computer architecture
Shell/Bash
0 vote168 views1 answer
How to define a command in bashrc
Shell/Bash
0 vote196 views1 answer
How to get rid of activate windows watermark 2021
Shell/Bash
0 vote181 views1 answer
Linux copy files to current directory
Shell/Bash
0 vote166 views1 answer
Gzip folder with tar and exclude directories
Shell/Bash
3 votes159 views2 answers
Install homebre windows
Shell/Bash
0 vote176 views2 answers
Linux history unique commands
Shell/Bash
16 votes164 views3 answers
Flutter web run using vscode
Shell/Bash
3 votes175 views2 answers
How to push code on bitbucket
Shell/Bash