Re: Bulk-copy?

From: Alfred Perlstein <bright(at)wintelcom(dot)net>
To: Thomas Weholt <Thomas(at)cintra(dot)no>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Bulk-copy?
Date: 2000-06-02 08:56:20
Message-ID: 20000602015619.I17973@fw.wintelcom.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

* Thomas Weholt <Thomas(at)cintra(dot)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(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."

In response to

  • Bulk-copy? at 2000-06-02 06:08:33 from Thomas Weholt

Browse pgsql-novice by date

  From Date Subject
Next Message Alfred Perlstein 2000-06-02 08:57:57 Re: Performance - fsync-off
Previous Message Ron Chmara 2000-06-02 08:53:54 Re: Performance