Accessing large objects

From: c k <shreeseva(dot)learning(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Accessing large objects
Date: 2009-03-21 08:37:40
Message-ID: d8e7a1e30903210137y6e4a2f37wb1181666e618fbdc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Diogenes Caraballo 2009-03-21 13:31:49 Re: vacuuming and reindexing
Previous Message Tom Lane 2009-03-21 04:58:07 Re: pg_dump formatting

Browse pgsql-general by date

  From Date Subject
Next Message esemba 2009-03-21 08:40:41 Re: Fulltext - multiple single column indexes
Previous Message Oleg Bartunov 2009-03-21 07:42:26 Re: Fulltext - multiple single column indexes