Cannot Connect Remotely to PostgreSQL DB

Using what seems to be standard psql commands in terminal, I cannot connect to my Postgresql DB on Render to manage tables etc.
Commands like:
psql -h <Host - **using my External Database URL**> -p <Port> -d <Name> -U <User> -W

I get:
psql: error: could not translate host name "postgresql://....." to address: nodename nor servname provided, or not known

I am not the most well-versed in this way of working but this seems straightforward from what I see around. Can anyone suggest anything?

Hi there,

Have you tried directly copying and using the psql command provided in the “Connect” dropdown (select “External”) in the Dashboard?

Regards,
Mike


Render Support Engineer, MT (UTC-6, UTC-7 in Winter)

I ended up using Postico, guess I’m good. answers still appreciated :slight_smile:

Glad you got it working! Thanks for letting us know.

Regards,
Mike


Render Support Engineer, MT (UTC-6, UTC-7 in Winter)