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

9 votes330 views5 answers
Poetry install
Shell/Bash
0 vote382 views1 answer
Diff remote file
Shell/Bash
0 vote340 views1 answer
Ackage libpng12-dev is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source E: Package 'libpng12-dev' has no installation candidate
Shell/Bash
6 votes315 views4 answers
Find file linux
Shell/Bash
0 vote311 views1 answer
Terraform version command
Shell/Bash
7 votes348 views1 answer
Ubuntu cmd change user of a file
Shell/Bash
0 vote373 views1 answer
How do I become the owner of a directory in linux?
Shell/Bash
0 vote346 views1 answer
Docker destroy all
Shell/Bash
0 vote352 views1 answer
Ubuntu grub repair
Shell/Bash
49 votes352 views6 answers
Bash for loop
Shell/Bash