You are wondering if the connection string for your Heroku Postgres database will change after the maintenance.
In most cases, no. After maintenance is completed, a new release is created for your app, which states that certain config vars have been updated, but the values stay the same. Your app still restarts with this change. It is advised to always reference the config var itself rather than connection string.