Array and JSON data type

[Theprasit]

Does UniDAC support postgresql Array and JSON data type?

If not what about PgDAC?

Regards,

Theprasit

[azyk]

UniDAC and PgDAC support the JSON data type and array in PostgreSQL. In UniDAC/PgDAC, for direct access to JSON fields, the TBlobField field type is used, for array fields - the TMemoField field type. Selection, data modification, creation and using indexes for fields with such types are supported on the server side.

For example, the code for data insert to the BLOB_FIELD field with the JSON type from the File.bin file will look like the following:

Code: Select all

  TBlobField(UniQuery.FieldByName('BLOB_FIELD')).LoadFromFile('File.bin');

And the code for reading data from the BLOB_FIELD field to the File.bin file - as follows:

Code: Select all

  TBlobField(UniQuery.FieldByName('BLOB_FIELD')).SaveToFile('File.bin');

[Theprasit]

Just do a testing on both Array and JSON. I can query a test table by passing SQL with Array and JSON syntax successfully. This is awesome and UniDAC is great.

Thank you and Regards,

Theprasit

[azyk]

We are glad to see that the suggested solution suits you. Thank you for your feedback. If any further questions come up, please contact us.