Memory usage with Blobs

[btrewern]

Using Zeos 6.5.1 Delphi 7.1 and PostgreSQL 8.1.4

I've been looking at saving files into Bytea fields on PostgreSQL and have found a few problems. It seems that currently there is no way of extracting files from the database without first loading them into a dataset and thereby into memory.

Does anyone know of a way round this as I don't want the memory footprint of my application to go through the roof if I start using largish files?

Regards,

Ben