pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
get the data size of a large object
3+ messages / 2 participants
[nested] [flat]

* get the data size of a large object
@ 2003-04-24 17:43  Stéphane Pinel <spinel@noos.fr>
  0 siblings, 1 reply; 3+ messages in thread

From: Stéphane Pinel @ 2003-04-24 17:43 UTC (permalink / raw)
  To: pgsql-interfaces

Is there a way to get the data size of a large object ? I would like to  
be able
to read an entire large object using lo_read function. Since this  
function needs
a "len" parameter as input, I have to know the size of the large  
object...

Any idea ?

Thanks.

------------------------------------------------------------------------ 
---
Stéphane Pinel
iChat/AIM: s.pinel
------------------------------------------------------------------------ 
---



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: get the data size of a large object
@ 2003-04-24 20:12  Jeroen T. Vermeulen <jtv@xs4all.nl>
  parent: Stéphane Pinel <spinel@noos.fr>
  0 siblings, 1 reply; 3+ messages in thread

From: Jeroen T. Vermeulen @ 2003-04-24 20:12 UTC (permalink / raw)
  To: Stéphane Pinel <spinel@noos.fr>; +Cc: pgsql-interfaces

On Thu, Apr 24, 2003 at 07:43:29PM +0200, Stéphane Pinel wrote:
> Is there a way to get the data size of a large object ? I would like to  
> be able
> to read an entire large object using lo_read function. Since this  
> function needs
> a "len" parameter as input, I have to know the size of the large  
> object...

Just seek to the end, remember the return value, and seek back.


Jeroen




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: get the data size of a large object
@ 2003-04-24 21:19  Stéphane Pinel <spinel@noos.fr>
  parent: Jeroen T. Vermeulen <jtv@xs4all.nl>
  0 siblings, 0 replies; 3+ messages in thread

From: Stéphane Pinel @ 2003-04-24 21:19 UTC (permalink / raw)
  To: Jeroen T. Vermeulen <jtv@xs4all.nl>; +Cc: pgsql-interfaces


Le jeudi, 24 avr 2003, à 22:12 Europe/Paris, Jeroen T. Vermeulen a  
écrit :

> On Thu, Apr 24, 2003 at 07:43:29PM +0200, Stéphane Pinel wrote:
>> Is there a way to get the data size of a large object ? I would like  
>> to
>> be able
>> to read an entire large object using lo_read function. Since this
>> function needs
>> a "len" parameter as input, I have to know the size of the large
>> object...
>
> Just seek to the end, remember the return value, and seek back.
>

Oh yes, my question was so stupid. Thanks a lot !

------------------------------------------------------------------------ 
---
Stéphane Pinel
------------------------------------------------------------------------ 
---




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2003-04-24 21:19 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-04-24 17:43 get the data size of a large object Stéphane Pinel <spinel@noos.fr>
2003-04-24 20:12 ` Jeroen T. Vermeulen <jtv@xs4all.nl>
2003-04-24 21:19   ` Stéphane Pinel <spinel@noos.fr>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox