Logstash JDBC Output to postgreSQL


(Phi Swap) #1

i would like to put a json in my database

It works fine but i would like to convert the json "properties" in string to store it in 1 column

"name":"Product",
"properties":
{
"type":"number",
"description":"Product identifier"
}

create table tx (
name text,
properties text
}

when i try this sample it works fine, It's normal properties is not a sub json

"name":"Product",
"properties":
{
"type":"number",
"description":"Product identifier"
}


(system) #2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.