Hi Tony,

Support for non-standard SQL types was added in 4.2:

https://lists.apache.org/thread/66nhvkzt1mqoh2h53h2x6sbx968kt2fy

We are mapping those types on the DB side as JDBC type OTHER. On the Java type 
it is mapped as org.apache.cayenne.value.Json.

Andrus


> On Nov 4, 2021, at 6:34 PM, Tony Giaccone <t...@giaccone.org> wrote:
> 
> So Postgres supports a json type in their database.  Clearly this isn't a
> type that's generally available, but it would be nice if the modeler
> supported the ability to add types, so in this way you could support the
> unusual types, that sometimes need to be used. Clearly I have no idea how
> hard this would be to implement in the modeler, but it sure would be a nice
> feature.
> 
> 
> Tony Giaccone

Reply via email to