Postgre Tutorial advanced

 sudo apt update

sudo apt install postgresql postgresql-contrib

sudo -i -u postgres

psql

Create user

CREATE USER sandy WITH PASSWORD yourpassword;

\du

===========gran access

ALTER USER sandy WITH SUPERUSER;

===========create db

CREATE DATABASE books;

===========set db to user

GRANT ALL PRIVILEGES ON DATABASE "books" to sandy;

\du

==========Login db

psql -h localhost -d dbname -U userdb -p 5432

Export 

pg_dump -U sandy -h localhost  -p 5432 books > books130622.sql

Import 

psql -U sandy -h localhost -p 5432  books < books130622.sql