Re: [GENERAL] Accessing large objects

2009-03-24 Thread Albe Laurenz 
 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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Accessing large objects

2009-03-21 Thread c k 
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