OK that's exactly what I want - thanks! I wasn't aware of a global
psqlrc file.
BTW, I still think the default behaviour is incorrect...
But at least I can work around it now and have the change be global. :)
Thanks again
John Sidney-Woollett
Peter Eisentraut wrote:
> John Sidney-Woollett wrote:
>
>>I'd like to see a global setting that I could change, not one on a
>>user by user basis...
>
>
> Then I suggest that in addition to the per-user configuration file
> ~/.psqlrc you implement a global configuration file
> /etc/postgresql/psqlrc. That would be the place you could put such a
> setting.
>
>
>>I'd also like a message in the Welcome banner telling me what the
>>current AUTOCOMMIT setting is...
>
>
> Put
>
> \echo 'AUTOCOMMIT is' :AUTOCOMMIT
>
> in your configuration file and you're done.
>