JSON with PostgreSQL not serializing correctly
I have define my field like this:
Which looks fine when I look at the table structure.
Now I have the following object I'm creating/updating, which has a string[] as hostnames:
After this is added, the value in the database is escaped like this:
This does not look correct, it looks like wrongly serialized. Or what am I doing wrong here?
The following SQL should extract the first value, however because it's wrongly serialized, it gives me the JSON serialization as the first value:
Which looks fine when I look at the table structure.
Now I have the following object I'm creating/updating, which has a string[] as hostnames:
After this is added, the value in the database is escaped like this:
This does not look correct, it looks like wrongly serialized. Or what am I doing wrong here?
The following SQL should extract the first value, however because it's wrongly serialized, it gives me the JSON serialization as the first value:
