martinov

-- Source: https://dataedo.com/kb/query/postgresql/find-all-json-columns

select col.table_schema,
       col.table_name,
       col.ordinal_position as column_id,
       col.column_name,
       col.data_type
from information_schema.columns col
join information_schema.tables tab on tab.table_schema = col.table_schema
                                   and tab.table_name = col.table_name

martinov

#!/bin/bash

curl -X POST \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer another-super-secret-key" \
  -d @"${0%/*}/data.json" \
  http://dikar-consult.mmartinov.com:3030/incoming-order