Re: psql + autocommit - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: psql + autocommit
Date
Msg-id 200409152008.09660.peter_e@gmx.net
Whole thread Raw
In response to Re: psql + autocommit  (John Sidney-Woollett <johnsw@wardbrook.com>)
Responses Re: psql + autocommit  (John Sidney-Woollett <johnsw@wardbrook.com>)
List pgsql-general
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/


pgsql-general by date:

Previous
From: Ron St-Pierre
Date:
Subject: Re: disk performance benchmarks
Next
From: John Sidney-Woollett
Date:
Subject: Re: psql + autocommit