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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
