On Mon, May 21, 2001 at 09:38:11PM +0200, Bj?rn Lundin wrote:
> Hi!
> Is there a way of turning autocommit of in psql ?
> It would be nice for people used to Oracle's SQL*Plus.
> No fatal error has occurred yet, but some minor problems could have been
> avoided if rollback was possible when the fingers on the keyboard are
> faster than the brain :)
Yes, just start an explicit transaction with "BEGIN" -- this disables
autocommit (so when you want to commit your transaction, you'll need
to do "COMMIT" by hand).
Cheers,
Neil