It was the same for me - back when I first learned SQL I really tried to use Postgres but phpMyAdmin was so much better than pgMyAdmin that I gave up. A lesson in the importance of user-friendly UIs. Perhaps some developers can really nail a schema on first go, but for me it usually takes a lot of tweaking before I can really understand what I want and the CLI is not the best place for that, especially if my mind is deep in the code I am trying to write.
JetBrains' IDEs have Postgres data source support, I find that GUI really rather excellent for anything I've had to do and couldn't remember the syntax for.
phpPgAdmin, started ~2002:
http://phppgadmin.sourceforge.net/doku.php
Basically a port of phpMyAdmin to postgres. I used it for several years around ~2003-5.. it's nearly identical.
I’m a regular Postgres user and fan, but cut my teeth on LAMP. I can’t speak to the current state of the projects, but phpMyAdmin was vastly superior to phpPgAdmin in the 2000s. phpMyAdmin remains the best DB GUI I’ve ever used. (Although I haven’t used any GUI in quite a few years.)
Re:Postgres 11 – A First Look
by StreamBright on Saturday September 22, 2018 @05:35AM
(#18045272)
There are tons of tools like phpMyAdmin for Postgres.
Early on in my career, the biggest selling point for Mysql was the excellent web admin tool "phpMyAdmin" - it really helped get applications off the ground, since the core of most modern systems is the data model. Users could modify data, without your needing to create a UI for that use case.
It conveniently used the same stack as the rest of the software, but I remember spinning up a phpMyAdmin instance even after moving away from PHP as an application language.
Postgres still doesn't really have anything like that! The closest that comes to mind is Django's Admin tool.