Querying Large Objects

David Kerr wrote:

I'm having a heck of a time trying to track this down.
Is it possible to retrive a large object from psql/pgbench?

I don't want just the OID, i want the actual streamed data.

I'm doing a timing comparison between bytea and lo's. So it'd
be ideal if I can pull it with pgbench.

You can do it with SQL:

SELECT loread(lo_open($1, 262144), 1073741819)

Where $1 is to be replaced with the OID of the large object.

Yours,
Laurenz Albe