I've been using pgadmin 4 successfully until I ran a Ubuntu 18.04 update, which had the update for pgadmin 4 included. Now, whenever I run a 'Select * from table', instead of displaying the results, it displays 'table_oid'. I googled this and there was mention of a .pgadmin.conf, which I cannot find on my system anywhere. Also tried to uninstall/reinstall, which did not work.
Tried to uninstall/reinstall, tried manually creating the .pgadmin folder and the pgadmin.conf file, but this did not help. I'm sure it's something simple, but it's confusing because of the different ways it can be installed, file locations, and all of that. My python version is 3.6. Appreciate anything that can point me in the right direction.
You need to upgrade the python3 package psycopg2 to version >= 2.8 (see here).