How to load 6 MB file to database

From: "Andrus Moor" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: How to load 6 MB file to database
Date: 2006-02-24 12:04:27
Message-ID: dtmsr2$26ls$2@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm using Postgres 8.1 and latest ODBC driver in Windows XP with 256 MB RAM.

When trying to insert a 6 MB binary file to a bytea field, out-of-memory
error is writeen to ODBC log file and insert fails. Smaller files are
inserted OK

Any idea how to load 6 MB file to a bytea field or avoid out-of memory error
?

Is it possible to add data to a single bytea field incrementally using
separate insert of update
statements each adding for example 100 KB of data ?

Or is there other solution ?

Andrus.

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2006-02-24 12:10:41 Re: Oracle purchases Sleepycat - is this the "other shoe"
Previous Message Andrus Moor 2006-02-24 11:57:48 How to read odbc and pgadmin lists from news server