Search code examples
postgresqlpostgispgadmin-4

Why does running a query return 'table_oid' under messages and nothing under Data Output

Running any sort of query on pgAdmin 4 just returns a 'table_oid' under messages.

I am able to get the necessary data when running the query from the command line, for example 

SELECT ST_MakePolygon(ST_GeomFromText('LINESTRING(75.15 29.53,77 29,77.6 29.5, 75.15 29.53)'));

I understand that table_oid refers to the object id of the table, but I have no idea how to access it.

Pardon me please if it is a simple question, but I am unable to find any resources online

Expected:

010300000001000000040000009A99999999C9524048E17A14AE873D4000000000004053400000000000003D4066666666666653400000000000803D409A99999999C9524048E17A14AE873D40

Actual:

table_oid

Solution

  • From pgAdmin 4 project tracker: Temporary solution until next release and tested in my ubuntu 18.04 machine:

    Replace these two 2 files:

    /usr/share/pgadmin4/web/pgadmin/tools/sqleditor/__init_*_py /usr/share/pgadmin4/web/pgadmin/tools/sqleditor/command.py

    Link to files:

    Note: The first file's name is __init_*_py, without the *.