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!
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 |