Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

like image 418
Philip Wee Avatar asked Jul 28 '19 08:07

Philip Wee


1 Answers

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:

  • __init_*_.py

  • command.py

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

like image 55
jhuamanchumo Avatar answered Nov 18 '22 17:11

jhuamanchumo