Thread: setting autocommit off in pgsql

Hi all
    How to set autocommit off. I want transactions which requires explicit
commit and after commit a new transaction is started as in Oracle sql plus.
When using start transaction it requires to type start transaction every
time.

Antony Paul

Use BEGIN  to open a transaction ( that's the difference to Oracle )
and COMMIT or ROLLBACK to close it.

Antony Paul schrieb:
> Hi all
>     How to set autocommit off. I want transactions which requires
> explicit
> commit and after commit a new transaction is started as in Oracle sql
> plus.
> When using start transaction it requires to type start transaction every
> time.
>
> Antony Paul
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

"Antony Paul" <antonypaul24@hotmail.com> writes:
>     How to set autocommit off.

In psql, \set AUTOCOMMIT off

            regards, tom lane