Yes, that works and I am able to receive a response from that command.
Here is the psql command that I am using.
psql postgres://postgres:<password>@<appname>-db.internal:5432
When creating the database, I received both a Proxy Port and PG Port, I’ve tried both in the command above and receive the same response.
The fly postgres docs does show this as the command to use:
psql postgres://postgres:secret123@appname.internal:**5432**
I assume the ** around the port is a typo, I get the following error when including those asteriks.
psql: error: invalid integer value "**5432**" for connection option "port"