How to set up DAB with Postgresql flexible server on azure? Connection string format

[regtm]

I'm trying to connect a DAB Container APP to a flexible postgresql server in azure. Since the azure portal provides an ADO.NET connection string, I provide that string as the connection string environment variable, after filling in the password.
I validated the connection credentials via psql and pgadmin4, but when running the dab container with the connection string, containing the same credentials, I run into 28P01: password authentication failed for user "adminTerraform".

I've noticed, that this quickstart (guide) initializes dab with a connection string that differs from the one provided by the flexible postgresql server:
Guide: "Host=localhost;Port=5432;Database=bookshelf;User ID=postgres;Password=<your-password>;"
Server: Server={server}.postgres.database.azure.com;Database=db;Port=5432;User Id={user};Password={password};Ssl Mode=Require;
Changing between "Host" and "Server" did not make any difference though.

What is the correct format for a connection string when connecting to a postgresql database?

Full exception from the dab container:

Azure.DataApiBuilder.Service.Startup[0]
      Unable to complete runtime initialization. Refer to exception for error details.
      Azure.DataApiBuilder.Service.Exceptions.DataApiBuilderException: Cannot obtain Schema for entity book with underlying database object source: public.books due to: 28P01: password authentication failed for user "adminTerraform"
         at Azure.DataApiBuilder.Core.Services.SqlMetadataProvider`3.HandleOrRecordException(Exception e) in /_/src/Core/Services/MetadataProviders/SqlMetadataProvider.cs:line 100
         at Azure.DataApiBuilder.Core.Services.SqlMetadataProvider`3.PopulateObjectDefinitionForEntity(String entityName, Entity entity) in /_/src/Core/Services/MetadataProviders/SqlMetadataProvider.cs:line 1116
         at Azure.DataApiBuilder.Core.Services.SqlMetadataProvider`3.PopulateObjectDefinitionForEntities() in /_/src/Core/Services/MetadataProviders/SqlMetadataProvider.cs:line 1054
         at Azure.DataApiBuilder.Core.Services.SqlMetadataProvider`3.InitializeAsync() in /_/src/Core/Services/MetadataProviders/SqlMetadataProvider.cs:line 289
         at Azure.DataApiBuilder.Core.Services.MetadataProviders.MetadataProviderFactory.InitializeAsync() in /_/src/Core/Services/MetadataProviders/MetadataProviderFactory.cs:line 65

[regtm]

The ADO.NET format works fine, make sure though to use single quotes when using the string in the shell as the special characters in the password might be interpreted otherwise 😭