How to connect to PostgreSQL database using pgAdmin 4?

 How to connect to PostgreSQL database using pgAdmin 4? In order to set up a connection to the PostgreSQL database, run pgAdmin 4, for example, from the Start menu. As a result, pgAdmin 4 will start. Then click the menu "Object->Create->Server" or right-click on the item "Servers" and select "Create->Server". The server connection settings window will open. On the General tab, we invent and enter the name of our server in the Name field. On the Connection tab, enter the server IP address, username, password, and if you want, you can check the “Save password?” to save the password and not to enter it every time you connect. If the standard port (5432) of the PostgreSQL server has been changed, then you also need to change it here. Press the "Save" button. Note! The PostgreSQL server must be installed, configured and running. We considered an example of installing and configuring PostgreSQL DBMS on Linux Debian in the material “Installing ...

SQL


 SQL (Structured Query Language) is a structured query language, with the help of which special queries are written to the database. SQL is a declarative programming language.


With the help of the SQL language, we carry out all actions in the database, in particular, we create data, change them, delete and retrieve this data, in other words, SQL is the language for user interaction with the database.


The SQL language does not take a leading place in authoritative ratings, although in some ratings it is in the TOP 10, and according to Stack Overflow it even takes the 3rd line. However, in today's world with the growth of information and data, the SQL language is becoming increasingly valuable. So, in almost any job related to development, in most cases you will meet a requirement for knowledge of SQL. What makes this language very popular and in demand.