| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "c k *EXTERN*" <shreeseva(dot)learning(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] Accessing large objects |
| Date: | 2009-03-24 09:31:30 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C202FF64FA@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2009-03-24 14:13:47 | Re: clog files |
| Previous Message | fatih ozturk | 2009-03-23 15:44:32 | clog files |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2009-03-24 09:34:06 | Re: Move PG installation to a new computer |
| Previous Message | Torsten Zühlsdorff | 2009-03-24 09:23:43 | Re: Fulltext: problem with english words in german text |