I have a very basic PostgreSql table. Despite the simple table schema, I cannot query it via PgAdmin4.
The View Data
option is unresponsive; Query Tool
option becomes unresponsive after a few attempts in opening and closing the panel. When the Query Tool is eventually (somehow) launched, a trivial SQL statement like
SELECT * FROM test_table
will spin forever and never display.
The diagram above shows the exact same table, which is okay under PgAdmin3.
The table was created empty. Then added with a row. But it threw errors about not having a Primary Key. Which also threw errors when I tried to set a Primary Key. So I used TeamPostgreSql to set a Primary Key. So all is good under PgAdmin3 now. Hence I'm really curious about what's going on with PgAdmin4?
I'm running pgAdmin4 v3.0 and I've put localhost
as host name.
I mean, left panel > servers > create > server
and then connection tab > host name
I could not query tables, clicking on view/edit data
> all rows
had no results (nor error log entries).
After I changed server name from localhost
to 127.0.0.1
, all worked as expected!
I hope it helps, because I've lost so much time on this and could not find a proper answer.