On , I learnt ...

That ~/.psqlrc options can override command-line options

I was trying to work out why this psql command wasn’t printing results in tab-separated format:

psql -d $DATABASE -AF $'\t' -c "$SQL"

This should work as:

But it wasn’t working.

Turns out that a setting in my ~/.psqlrc was overriding the -A option:

\pset format wrap

To get the above command to work, the --no-psqlrc option was needed:

psql -d $DATABASE --no-psqlrc -AF $'\t' -c "$SQL"