Re: Disabling autocommit at the psql prompt

From: Thierry Missimilly <THIERRY(dot)MISSIMILLY(at)BULL(dot)NET>
To: Anupama Laxminarayan <anupama(at)cs(dot)unipune(dot)ernet(dot)in>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Disabling autocommit at the psql prompt
Date: 2003-05-26 07:09:34
Message-ID: 3ED1BDAD.5930B65A@BULL.NET
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Attachment Content-Type Size
THIERRY.MISSIMILLY.vcf text/x-vcard 327 bytes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mohan A 2003-05-26 12:15:21 Language Support
Previous Message Rishabh Chandra 2003-05-26 07:02:28 sql datatypes storage