I am aiming to use R to connect to a database within PostgreSQL, for which I need to know the database host, port and user.
Do you know how I can find these details within PostgreSQL?
Thanks.
If you are using psql and already logged into the database, you can use the below command to display connection info
\conninfo
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With