filmov
tv
How To Install PostgreSQL Server In Ubuntu Linux

Показать описание
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
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