4

When I start a psql session, I would like certain meta commands to already be set.

For instance:

\x auto
\set ON_ERROR_STOP on

I was hoping to find an rc or config file but couldn't. The command line options don't seem comprehensive either.

1 Answer 1

5

You are looking for the .psqlrc file. Per documentation:

psqlrc and ~/.psqlrc

Unless it is passed an -X or -c option, psql attempts to read and execute commands from the system-wide startup file (psqlrc) and then the user's personal startup file (~/.psqlrc), after connecting to the database but before accepting normal commands. These files can be used to set up the client and/or the server to taste, typically with \set and SET commands.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.