Postgres: jsonb column is not visible in TSQLQuery
lazarus / 16-Databases

----------------------------------------------------------------------
antispam88 · 2019-04-01 22:06

Hi,
I'm trying to query a table with a jsonb column using TSQLQuery.
The table has 11 columns and the last one is the jsonb column (column
name = "setup"):
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i select id,
id2, date1, date2, txt1, txt2, txt3, testid1, testid2, description,
setup from table1;
But I'm getting only a FieldCount of 10, the last column is not
returned.

pgadmin returns all columns using the same select statement.

Is jsonb not supported in TSQLQuery or is there a postgres function to
get the whole json?

Best regards,
antispam88


Windows 10 Prof x64
Lazarus: 2.0.0
FPC: 3.0.4
x86_64-win64-win32/win64
Postgres 11.2-1