Large Object

From: Mustafa Timur GÖKÇE <timur(dot)gokce(at)rt(dot)net(dot)tr>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Large Object
Date: 2000-12-19 17:02:28
Message-ID: 01e401c069dd$77c40d80$448041d4@mutigo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi! , I want to ask you about large objects or BLOBs

I need to know the size of a large object that I have already know its indice number.

For example ,

One of my large objects in my database is indicated with xinv223345 and xinc223345

if I use this command

select lo_export(223345,'/tmp/myfile')

I can easily export this large object to my file system and see its size by " ls " command. BUT , i want to know this object's size whitout exporting it to my file system.

As a brief , Is there any postgresql command or statement that gives you a large object's SIZE which is in your database ?

Or you can advise me perl or C modules.

Thanks alot!

Browse pgsql-admin by date

  From Date Subject
Next Message Joseph 2000-12-19 18:56:33 Help me for "DBI->connect failed: Sorry, too many clients already."
Previous Message Serge Canizares 2000-12-19 15:17:59 Re: SQL statement limit