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"):
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