How can I use Digital Oceans DB CA Cert in App Platform?

I am struggling to use the CA Cert provided by my Digital Oceans PSQL database.

I am using Knex in my Node.js Express application. Here is my Knex config:

  production: {
    client: 'postgresql',
    connection: {
      connectionString: process.env.PSQL_CONNECTION_STRING,
      ssl: {
        ca: Buffer.from(process.env.CA_CERT_BASE_64 ?? '').toString('utf-8')
      }
    },
    pool: {
      min: 2,
      max: 10
    },
    migrations: {
      tableName: 'knex_migrations'
    }

I have tried the following things:

1. Store ${my-db.CA_CERT} in an environmental variable and referencing it
2. Copying and pasting the raw string from downloading the CA Cert and using it as a env var.
3. Encoding the CA Cert string into base 64 and setting that into an environment variable. Then decoding it in my source code so the formatting for the cert is kept.
4. using $ echo on the env var to check it is properly set

After all of this, I get the following error:

Error: self signed certificate in certificate chain

By setting NODE_TLS_REJECT_UNAUTHORIZED=0 in my environmental variables, I am able to connect to my database. However, I would like to avoid doing that.

Does anyone have any insight on what can be done?