postgresql相关操作
sudo -u postgres psql
create database mydb;
create user myuser with encrypted password 'mypass';
grant all privileges on database mydb to myuser;
alter user <username> with encrypted password '<password>';
#Granting privileges on database
grant all privileges on database <dbname> to <username> ;
#Creating user
sudo -u postgres createuser <username>
#Creating Database
sudo -u postgres createdb <dbname>
#Giving the user a password
sudo -u postgres psql