Skip to main content

Community

Postgres Composite Column Support

Planned

Please sign in to leave a comment.

Comments

2 comments

    Hi Matt,

    We have this feature on the roadmap, but without a specific timeline at this point. Let us evaluate it deeper and see if it's possible to prioritize.

    In the meantime, can you please share examples of composite types that you use?

    Thanks,
    Val Kulichenko, Fivetran Product Team

    Sure, here you go. Let me know if you need any other info!

    I would be happy if the data even landed as simple json or string values. I can parse the data as needed once it's landed in my destination.

    • total_market_valuemoney_value (amount numeric(78,0) + currency_code currency_code)
    • report_netmoney_value (amount numeric(78,0) + currency_code currency_code)
    • dollar_amountmoney_value (amount numeric(78,0) + currency_code currency_code)
    • outstanding_principalmoney_value (amount numeric(78,0) + currency_code currency_code)
    • custom_rate_bpsrate_value (basis_points numeric(20,4))