Problems with insert (fwd) - Mailing list pgsql-general

From John McKown
Subject Problems with insert (fwd)
Date
Msg-id Pine.LNX.4.21.0007271927150.22004-100000@linux2.johnmckown.net
Whole thread Raw
List pgsql-general
>1. The insertion could be fast, if I'd switch off autocommit. In
>adabastcl I have the commands to do this. Is something like this
>possible via sql, psql oder the tcl-extension ? I usually use psql to
>insert data from a file, but a tcl solution would help to.

<snip>

In psql, simply use the "begin" command to begin a transaction. Now do
your "insert" commands. Finish up with a "commit" command. I think this is
the same in all the various interface languages. At least I've seen things
like (in python>:

import pg;
db=pg.DB(....)
db.query('BEGIN')
... more db.query('INSERT ...') commands
db.query('COMMIT')



pgsql-general by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: 4 billion record limit?
Next
From: Joseph Shraibman
Date:
Subject: Re: