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.