Recent

Author Topic: Postgres: jsonb column is not visible in TSQLQuery  (Read 272 times)

antispam88

  • Jr. Member
  • **
  • Posts: 51
Postgres: jsonb column is not visible in TSQLQuery
« on: April 02, 2019, 12:06:29 am »
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]
  1. 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