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