I am learning to use
psql to work with a postgres database on linux.
I can connect using a long connection string, for example by running:
However, I would like to save the details of my connection string somewhere, to simplify the command to connect to the database.
I've added the parameters to
~/.pgpass, and I've also changed the environment variables
PGUSER. However, I'm not sure how to tell
psql to source connection information from either
~/.pgpass or the environment variables. When I just type
psql I get an error, and I can tell from the details of the error that it is trying to connect using default parameters, like port 5432 instead of my specific port.
So how to I tell
psql to use the parameters in
~/.pgpass or the environment variables? Or more broadly, how can I save my connection information to simplify the command to connect in the future?