Re: psql + autocommit

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.
>