You need to use the PUBLIC_URL for external connections like psql

Thanks will give it a shot

@TotalDev did it work?

yes it did thank you!

What is the best postgres client to view data?

I use Beekeeper Community Version!

PGAdmin is good too

So with PGAdmin, theres no way to connect with a db URL is there?

Let me check, opening it up

yeah, on pgadmin you have to individually fill each field

on the 'HOST' you're going to use the TCP proxy domain, you can find it in the 'Settings' tab

'PORT' is going to be the TCP proxy port, the rest of the fields like 'USER' and 'PASSWORD' you can find in the env vars tab

Thanks for the detailed response!

I ended up just using the URL and downloaded beekeeper 🙂

Nice!

Can I mark this thread as solved?

yes please and thank you!!

!s