There is a program called "pspg" that makes it easy to browse query results in a terminal... but it would be beneficial for you to learn the SQL syntax to do things such as create user.
I am looking for a tool other than pgAdmin3 for Raspberry Pi running on Debian 10 Buster. I need basic things like create user, run SQL on tables, view structure of a table.
pgAdmin3 is barely running and raising a lot of errors. pgAdmin4 is not in "apt" list of applications and I really do not like that I have to run a browser for it. There are a lot of alternatives for Windows based solution. I cannot find something for Raspberry Pi.
It would be good to have a free tool though I am willing to pay a small fee for a tool that will do my basics.