Thread: Disabling autocommit at the psql prompt

Hi
  Is there a way of disabling the autocommit feature at the psql command
prompt . I do not intend to explicitly start a transaction with BEGIN.
thanks
anupama

--

On Thursday 22 May 2003 13:04, Anupama Laxminarayan wrote:
> Hi
>   Is there a way of disabling the autocommit feature at the psql command
> prompt . I do not intend to explicitly start a transaction with BEGIN.

SET autocommit to OFF;


Ian Barwick
barwick@gmx.net

SET AUTOCOMMIT= false;

Should work.
    Thierry

Anupama Laxminarayan wrote:

> Hi
>   Is there a way of disabling the autocommit feature at the psql command
> prompt . I do not intend to explicitly start a transaction with BEGIN.
> thanks
> anupama
>
> --
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster