Postgres Pro
Downloads
Home   >   mailing lists

What is the syntax turn off auto commit? - Mailing list pgsql-sql

From Raymond Chui
Subject What is the syntax turn off auto commit?
Date
Msg-id 3B557E97.88E787AC@noaa.gov
Whole thread Raw
Responses Re: What is the syntax turn off auto commit?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
Tree view 

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

pgsql-sql by date:

Previous
From: Jan Wieck
Date:
Subject: Re: SPI_exec does not return!
Next
From: Gary Stainburn
Date:
Subject: pl/pgsql - code review + question