Re: Bulk-copy? - Mailing list pgsql-novice

From Alfred Perlstein
Subject Re: Bulk-copy?
Date
Msg-id 20000602015619.I17973@fw.wintelcom.net
Whole thread Raw
In response to Bulk-copy?  (Thomas Weholt <Thomas@cintra.no>)
List pgsql-novice
* Thomas Weholt <Thomas@cintra.no> [000602 01:45] wrote:
> Hi,
>
> I need to insert about 2000-10000 records into a database. I`m using Python
> to do this. Is there a way to use some form of bulk copy that will do this
> faster than plain-old insert for each and every record?

I don't know if there's python bindings for it, but you may want to look
to at the COPY stuff in the manuals, it's helped me quite a bit.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

pgsql-novice by date:

Previous
From: Alfred Perlstein
Date:
Subject: Re: Performance - fsync-off
Next
From: "Anthony E. Greene"
Date:
Subject: [OT] How to avoid using Reply-All on this list