Thread: 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.
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