showing DETAIL of sql error message

[kfirufk]

I'm using vscode 1.74.2 with SQLTools extension v0.26.0 with postgresql 15.

when I run a query that results in an error in psql it returns error output in several namespaces, for example in my case when i run a function that i created the returns wrong result type, it's divided to 3 sections:

ERROR:  structure of query does not match function result type
DETAIL:  Returned type numeric does not match expected type integer in column 11.
CONTEXT: SQL statement "..."

when I try to execute it i only see the error, the detail is important to understand exactly what went wrong

i tried looking at the sql console messages but it only shows the error as well.

am i missing something? is this something configurable ? if it was it looks like it should have been enabled my default