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 vote174 views1 answer
GIT starting an Interactive Rebase session
Shell/Bash
0 vote175 views0 answer
Shell/Bash
5 votes261 views3 answers
Linux show groups
Shell/Bash
3 votes137 views1 answer
Firebase deploy rules
Shell/Bash
74 votes180 views6 answers
Github clone branch
Shell/Bash
0 vote171 views1 answer
Install gron
Shell/Bash
0 vote226 views1 answer
How to use msw with
Shell/Bash
-2 votes403 views4 answers
How to install mongodb database in ubuntu version
Shell/Bash
0 vote186 views1 answer
Managed mode linux kali
Shell/Bash
32 votes184 views6 answers
Docker compose install ubuntu
Shell/Bash