Support arrays in PostgresSQL dialect

[ivanyu]

Currently, PostgreSQL dialect have no support for arrays. This will be a useful feature to have.

[ttrading]

Does this mean we cannot submit an array of JSON so we need to keep sending individual JSON with schema attached?

[willyborankin]

No you can store you data as JSON. This issue is about ARRAY type in PgSQL (https://www.postgresql.org/docs/11/arrays.html)

[ttrading]

what should my schema look like then if i want to insert an array in this form:

[
{
"text": "Hello1",
"sent_at": 1560507792000.001
},
{
"text": "Hello2",
"sent_at": 1560507794000.001
}
]

[willyborankin]

Please see my answer in issue #86