How do composite custom types look like in PostgREST?

[dreinon]

I would like to know how user-defined composite custom types look like in a select query and what's the format I have to follow to do an insert in a table a column of which is a composite type.

Thanks 🙂

[wolfgangwalther]

I would like to know how user-defined composite custom types look like in a select query

Have a look at this old thread, there's an example: #837 (comment)

(Ignore the whole bug thing - it's working as expected)

and what's the format I have to follow to do an insert in a table a column of which is a composite type.

See #837 (comment). It's a bit older, but still valid. You can either make it a string according to postgresql text->composite type conversion or make it an object, which will be parsed into the composite type.

[dreinon]

Thanks!