I am trying using Azure Postgres for my application backend and realize that I can't use username and password I normally use. I need to generate the token and then use token as password.
reference: https://docs.microsoft.com/en-us/azure/postgresql/concepts-aad-authentication
Questions
Is there a way I can use username and password (not token) with Azure AD user or SPN?
If not how to use SPN with my application? how to refresh token?
Does azure postgres local user makes more sense ?