Amazon RDS now supports custom data types in Trusted Language Extensions for PostgreSQL

https://aws.amazon.com/about-aws/whats-new/2023/09/amazon-rds-custom-data-types-trusted-language-extensions-postgre-sql/