Re: psql + autocommit

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: John Sidney-Woollett <johnsw(at)wardbrook(dot)com>
Cc: postgres general <pgsql-general(at)postgresql(dot)org>
Subject: Re: psql + autocommit
Date: 2004-09-15 18:08:09
Message-ID: 200409152008.09660.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Sidney-Woollett 2004-09-15 18:33:09 Re: psql + autocommit
Previous Message Ron St-Pierre 2004-09-15 18:05:38 Re: disk performance benchmarks