Is there a psql client config file analogous to $HOME/my.cnf for mysql ?

postgresql psql
Jerry picture Jerry · May 7, 2013 · Viewed 7.9k times · Source

That is, a local file on the client machine with default "host", "port", "user" values, etc., so that I don't have to enter them on the command line each time?

Answer

Clodoaldo Neto picture Clodoaldo Neto · May 7, 2013

Use the password file with lines like:

hostname:port:database:username:password

If you always log into the same host:db:port:user then this will make it:

*:*:*:*:mypassword

Related questions

PostgreSQL "DESCRIBE TABLE"

How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)?

Read More
Run a PostgreSQL .sql file using command line arguments

I have some .sql files with thousands of INSERT statements in them and need to run these inserts on my PostgreSQL database in order to add them to a table. The files are that large that it is impossible to …

Read More
How to switch databases in psql?

In MySQL, I used use database_name; What's the psql equivalent?

Read More