An error occurs after attaching "postgres" database for a PostgreSQL account

[v-chenzha]

OS: Win10
Build Version: 20221220.1

Repro Steps:

1. Create a PostgreSQL account.
2. Expand PostgreSQL account -> Right click "postgres" -> Copy Connection String.
3. Attach "postgres" database with connection string?ssl=true.
4. Check whether no error occurs after attaching "postgres" database.

Expect:
No error occurs after attaching "postgres" database.

Actual:
An error occurs after attaching "postgres" database.

More Info:
There is an extra single quote in the Connect String. No error occurs after deleting the single quotes, such as:
error connection string: postgres://cindy%40cindy-single:'Tcd...815615'@cindy-single.postgres.database.azure.com:5432/postgres
correct connection string: postgres://cindy%40cindy-single:Tcd...815615@cindy-single.postgres.database.azure.com:5432/postgres

[v-ruizh]

Verified on the build 20230822.5, the below error occurs for the attached "PostgreSQL server".

[JasonYeMSFT]

@v-ruizh I made a fix for this bug.

[v-ruizh]

Verified this issue on the extension build 20230911.4, another error occurs when attaching PostgreSQL server with the copied connection string.

The extra single quote still shows in the copied Connect String. Delete the extra single quote and add "?ssl=true" to the connection string, the error disappears.

[JasonYeMSFT]

I believe this has been fixed. If this still reproduces, please re-open this issue.

[v-ruizh]

Verified this bug on the latest build 20231017.2, it still reproduces. Reopen it.