No json results are shown in Data Output tab.

From: Henk F(dot) van Til <henk(dot)vantil(at)isp(dot)solcon(dot)nl>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: No json results are shown in Data Output tab.
Date: 2019-03-28 11:40:56
Message-ID: fd82d22694cb23c54f93ef463eba87be46a7e51f@ssw.solcon.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

Version: pgAdmin4 v4.3

When executing a query  the result is shown in the tab 'Data Output'. 

For example: SELECT * FROM table_foo LIMIT 5;

But when I run a function with json output, nothing is shown in the tab 'Data Output'. All notice messages are displayed in the 'Messages' tab including the messages 'Successfully run. Total query runtime: 64 msec. 1 rows affected.'

For example: SELECT function_foo('{"var1": "text", "var2": "text2"}');

When running the same function using the option 'download as CSV', I have the results.

Is this a setting in 'Preferences' which I overlooked. It worked in a previous version of pgAdmin4.

Thanks

Henk F. van Til

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Aditya Toshniwal 2019-03-28 12:35:16 Re: No json results are shown in Data Output tab.
Previous Message oldmart 2019-03-28 06:28:00 Cannot verify pgAdmin binary