X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C94189DDA73 for ; Mon, 26 Dec 2005 07:22:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25889-01-2 for ; Mon, 26 Dec 2005 06:22:01 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id A4E849DDF14 for ; Mon, 26 Dec 2005 06:50:47 -0400 (AST) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id jBQAjhS3028492 for ; Mon, 26 Dec 2005 16:15:43 +0530 Received: from amiindiahjwbgh (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 2F1413327DDfor ; Mon, 26 Dec 2005 16:15:43 +0530 (IST) Message-ID: <01dd01c60a0b$3644e2c0$cd00000a@amiindiahjwbgh> From: "sandhya" To: "postgre" Subject: Fw: reg:lseek&read ..pls Date: Mon, 26 Dec 2005 16:27:49 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01DA_01C60A39.4FD6F920" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:21 M:1 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.029 required=5 tests=[AWL=0.027, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.029 X-Spam-Level: X-Archive-Number: 200512/307 X-Sequence-Number: 20027 This is a multi-part message in MIME format. ------=_NextPart_000_01DA_01C60A39.4FD6F920 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ----- Original Message -----=20 From: sandhya=20 To: postgre=20 Cc: sandhya=20 Sent: Monday, December 26, 2005 2:27 PM Subject: reg:lseek&read ..pls 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 ------=_NextPart_000_01DA_01C60A39.4FD6F920 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 
----- Original Message -----=20
From: sandhya=20
To: postgre
Cc: sandhya
Sent: Monday, December 26, 2005 2:27 PM
Subject: reg:lseek&read ..pls

hi......
 
I stored few files into the database = and trying to=20 open it while accessing webserver...
In that case i need to just read the = contents of=20 the large object.
So...After importing all the files into = the=20 database i am trying to read the contents of the object.
But before that i need to know the size = of the=20 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=20 document.
Here i am mentioning the Oid and start = as 0 and len=20 as 2000.....But i am unable to get the whole contents of the = file.
If i want to get entire file = contents...How to=20 do?
What len i need to = specify?
Is there any thing to know the size of = the=20 object?
Please tell = me..............
 
Thank you
-Sandhya
------=_NextPart_000_01DA_01C60A39.4FD6F920--