How to load 6 MB file to database - Mailing list pgsql-general

From Andrus Moor
Subject How to load 6 MB file to database
Date
Msg-id dtmsr2$26ls$2@news.hub.org
Whole thread Raw
List 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.



pgsql-general by date:

Previous
From: "Andrus Moor"
Date:
Subject: How to read odbc and pgadmin lists from news server
Next
From: Bruce Momjian
Date:
Subject: Re: Oracle purchases Sleepycat - is this the "other shoe"