What is the syntax turn off auto commit?

From: Raymond Chui <raymond(dot)chui(at)noaa(dot)gov>
To: pgsql-general(at)postgresql(dot)org(dot)pgsql-sql(at)postgresql(dot)org
Subject: What is the syntax turn off auto commit?
Date: 2001-07-18 12:18:31
Message-ID: 3B557E97.88E787AC@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

The Subject says its all.

To speed up a bulk of INSERTs, I need to turn-off the auto commit 1st.
Then
at the end of INSERTs, issue COMMIT;
What is the syntax to turn off the auto commit? Thank you!

--Raymond

Attachment Content-Type Size
raymond.chui.vcf text/x-vcard 414 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben-Nes Michael 2001-07-18 12:43:38 Re: VACUUM ANALYZE
Previous Message Jan Wieck 2001-07-18 11:22:08 Re: undeleteable records

Browse pgsql-sql by date

  From Date Subject
Next Message Gary Stainburn 2001-07-18 14:10:23 pl/pgsql - code review + question
Previous Message Jan Wieck 2001-07-18 10:54:34 Re: SPI_exec does not return!