Обсуждение: Accessing large objects

Hello,

how to access large objects from the database when using PGAdmin like client applications? When a normal select is executed on lo type columns it gives only the number which refers to large objects stored in 'pg_largeobjects' table. When records from pg_largeobjects are fetched using select, it gives per page, binary string data. How to get the complete large objects from it?

I am using PG 8.3.6 on Windows XP SP3 for development.

Thanks,

CPKulkarni

> how to access large objects from the database when using
> PGAdmin like client applications? When a normal select is
> executed on lo type columns it gives only the number which
> refers to large objects stored in 'pg_largeobjects' table.
> When records from pg_largeobjects are fetched using select,
> it gives per page, binary string data. How to get the
> complete large objects from it?
>
> I am using PG 8.3.6 on Windows XP SP3 for development.

With the Large Object API, which can be used from almost all
programming APIs. It is documented in

http://www.postgresql.org/docs/8.3/static/largeobjects.html

Yours,
Laurenz Albe