How To Install PostgreSQL Server In Ubuntu Linux
To Install PostgreSQL Server in Ubuntu Linux, open terminal and type :

sudo apt update
sudo apt upgrade -y
sudo apt install postgresql
This will install postgresql server in your ubuntu system.
Now to login into your system, open terminal and type :

sudo -i -u postgres
after launching the postgres, type :

psql
Now you can easily create delete update or add new records into postgresql server database.
Here are also some addition commands to check :

\d - to check relations
\l - to list the databases in your postgresql server
\du - to list the roles

свернуть