execute transaction / insert rows

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: execute transaction / insert rows
Date: 2002-10-01 17:48:38
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB04C73FF5@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Howdy:

Running PostgreSQL 7.2.1 on RedHat Linux 7.2 kernel 2.4.7-10.

Are there any examples out there to insert / update
a table for every, say, 1000 records via SQL? I'm having
a hard time just inserting into the table ... it seems
that there isn't anything going on AND I need to commit
the transaction if the query gets killed somehow.

Thanks!

-X

Browse pgsql-general by date

  From Date Subject
Next Message Josh Berkus 2002-10-01 17:52:53 Re: [SQL] arrays
Previous Message Jean-Christian Imbeault 2002-10-01 17:46:22 count() for a select statement?