Re: psqlrc overrides command line flags in PG 9.6

Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com> writes:
> In PG 9.6 -c doesn't imply -X anymore, that's fine (well, not really,
> but let's say it is).

> However it seems it is no more possible to *override* what's in the
> psqlrc unless the config file is disabled altogether.

It was never possible to do that; the behavior has always been to
process the command line switches and then to run ~/.psqlrc.
Changing that would probably break at least as many things as it
fixes, not to mention being a complete mess implementation-wise.

You might be able to achieve the effect you're looking for with
a shell alias instead of ~/.psqlrc:

alias psql='psql --pset format=wrapped'

regards, tom lane