I am getting an 'able oid' when querying any tables using the Query tool.
When using the view / edit data option, everything works fine.
I came across this
<<<
The problem is due to python3-psycopg2. The latest pgadmin4 version requires psycopg2-2.8. But if you're on Debian/Ubuntu stable, apt installed v2.7. So you need to update it with pip :
sudo pip3 install -U psycopg2 >>>
The problem is that the upgrade to psycopg 2.8 doesn't work, as it's installed as part of the dtsutils package along with pgadmin4.