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 vote279 views1 answer
Cmdlet Invoke-Expression na posição de comando 1 do pipeline Forneça valores para os seguintes parâmetros: Command:
Shell/Bash
0 vote295 views1 answer
Shell script -z
Shell/Bash
1 vote272 views1 answer
How to set up git for github
Shell/Bash
0 vote269 views1 answer
Libqt5core5a is not installed.
Shell/Bash
0 vote259 views1 answer
Display id all image docker
Shell/Bash
25 votes277 views3 answers
Apt search installed package
Shell/Bash
0 vote296 views1 answer
Delete logs older than 7 days linux
Shell/Bash
0 vote263 views2 answers
Grep global configuration
Shell/Bash
0 vote266 views1 answer
Remote: Invalid username or password. github mac
Shell/Bash
0 vote292 views1 answer
Add user to a folder in ubuntu nginx
Shell/Bash