Is it possible to connect via pgAdmin to openserver?

Question

PostgreSQL

This question has some background. I am just migrating from mysql to pgsql while working on openserver. In the advanced settings of openserver, I specified postgresql, restarted and see that the "phppgAdmin" tab appeared, opening and connecting it at first I was delighted thinking "Oh, a similar interface, it's convenient", but then I realized that it's completely impossible to work here (it's not clear how to create auto-incrementing, foreign keys, missing some types, and more). After searching the Internet for guides, after reading the documentation, I realized that phpPgAdmin is not intended for working with databases (unexpectedly :) ), you need to download pgsql itself and a desktop application (which is no less convenient) to work with it, where you need to set a password.
After going through this thorny path and killing it all day, I came up with some questions: How can I connect to a particular database in pgAdmin via php (after all, when registering, I specified only a password)?. Why download a separate pgsql when the openserver has this setting and in the line configurations to work with it?
I apologize if I gave the wrong definitions or misunderstood something. I will be grateful for any help

Answer 1

You probably do not quite understand how the client-server architecture works. The database is the server and phpAdmin is the client. Typically, a database server is connected over a network. That is, theoretically, you can connect from your computer to the database on the server. If you know how. But usually, the database server is configured so that you can only connect with a client running on the same host. Judging by your description, you did not set it up yourself and it is better not to do it yourself yet.
The easiest thing in your case is to continue to use phppgAdmin provided by the host.

it is completely impossible to work here (it is not clear how to create auto-incrementing, foreign keys, the absence of some types, and much more).

You learn to work with the database not with the mouse, but by typing commands. Understand what DDL and DML are and then the wonderful world of databases will open to you. Where you can do anything in any client. If there are no data types, then for sure there are their analogues, which are simply called differently.
primary and foreign keys are generally the standard and are in any database. For autoincrement, you may need a sequence.
https://info-comp.ru/what-is-ddl-dml-dcl-tcl
https://postgrespro.ru/docs/postgrespro/10/datatype
mech.math.msu.su/~shvetz/54/inf /databases/chSerial...