Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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?

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


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group