reg:lseek&read ..pls

From: "sandhya" <sandhyar(at)amiindia(dot)co(dot)in>
To: "postgre" <pgsql-admin(at)postgresql(dot)org>
Cc: "sandhya" <sandhyar(at)amiindia(dot)co(dot)in>
Subject: reg:lseek&read ..pls
Date: 2005-12-26 08:57:04
Message-ID: 013501c609fa$57b48480$cd00000a@amiindiahjwbgh
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi......

I stored few files into the database and trying to open it while accessing webserver...
In that case i need to just read the contents of the large object.
So...After importing all the files into the database i am trying to read the contents of the object.
But before that i need to know the size of the object from which i am trying to get the contents.
How can i do this?

void
pickout(PGconn *conn, Oid lobjId, int start, int len)

I used the above sample one which is in postgres document.
Here i am mentioning the Oid and start as 0 and len as 2000.....But i am unable to get the whole contents of the file.
If i want to get entire file contents...How to do?
What len i need to specify?
Is there any thing to know the size of the object?
Please tell me..............

Thank you
-Sandhya

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message sandhya 2005-12-26 10:57:49 Fw: reg:lseek&read ..pls
Previous Message sandhya 2005-12-26 08:17:04 Re: lo_ functions