Refer below
Refer: https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-security
There is no restriction on connecting to Azure Database for PostgreSQL Flexible Server using tools like psql
or pgAdmin. These tools can be used to connect to the server and manage existing databases, run queries, and perform various database operations.
Refer: https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-connect-query-guide
Hope this helps