----- Original Message ---- From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> To: "Henk F. van Til" <henk.vantil@isp.solcon.nl> Cc: "pgadmin-support lists.postgresql.org" <pgadmin-support@lists.postgresql.org> Sent: Don, 28 Mrt 2019 13:35 Subject: Re: No json results are shown in Data Output tab.
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
--
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB Software Solutions | Pune