Server connection URL fails if username contains "@"

[timtilkee]

Hello ! We try to move to Azure Postgresql, but the DB's username always contains "@" (name@server), hence the full db url contains 2 "@" and fails: postgres://USERNAME@HOSTNAME:[email protected]:5432/postgres

We should be able to replace "@" by "%40" in the username: postgres://USERNAME%40HOSTNAME:[email protected]:5432/postgres, but it doesn't work ;(

Can you help us?

[Benjiiim]

According to PostgreSQL documentation :

Percent-encoding may be used to include symbols with special meaning in any of the URI parts, e.g. replace = with %3D.