Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I want to execute a set of commands before executing other queries using psql
The following is what I want to execute
psql << EOF
\setenv PAGER 'pspg -s 0'
\pset pager always
EOF
After executing this, I want to have an interactive shell with these parameters set.
I am looking for how to get interactive shell after this.
psql has a built-in feature to set defaults: the ~/.psqlrc file.
You can put any command in there that should be executed when you start psql
So just create that file and put:
\setenv PAGER 'pspg -s 0'
\pset pager always
into it.