Re: psql + autocommit

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.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/