X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 90BD6D7226 for ; Fri, 11 Nov 2005 06:12:29 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 43295-06 for ; Fri, 11 Nov 2005 10:12:25 +0000 (GMT) X-Greylist: delayed 01:20:59.978628 by SQLgrey- Received: from mars.amiindia.co.in (unknown [203.199.198.229]) by svr1.postgresql.org (Postfix) with ESMTP id 32EE7D6D17 for ; Fri, 11 Nov 2005 06:12:22 -0400 (AST) Received: from amiindiahjwbgh (unknown [10.0.0.205]) by mars.amiindia.co.in (Postfix) with ESMTP id E7DAB74C179; Fri, 11 Nov 2005 15:50:33 +0530 (IST) Message-ID: <017301c5e6a9$81f4e920$cd00000a@amiindiahjwbgh> From: "sandhya" To: "John Barham" Cc: "postgre" References: <012a01c5e69e$2e454500$cd00000a@amiindiahjwbgh> <4f34febc0511110110h1a1453f0tb3997a88b61dfd1e@mail.gmail.com> Subject: Re: Reg: Records Size Date: Fri, 11 Nov 2005 15:50:15 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.02 required=5 tests=[AWL=0.020] X-Spam-Score: 0.02 X-Spam-Level: X-Archive-Number: 200511/133 X-Sequence-Number: 19506 Hi John , Thank you. I am using C. Yes i mean to allocate memory of each tuple resulting from a query. Is there any function which gives the size of a tuple? If so...Please tell me/Tell me how to proceed to do that? Thanks&Regards, Sandhya R ----- Original Message ----- From: "John Barham" To: "sandhya" Cc: "postgre" ; "Sivakumar K" Sent: Friday, November 11, 2005 2:40 PM Subject: Re: [ADMIN] Reg: Records Size On 11/11/05, sandhya wrote: > please...tell me if there is possibility of finding out the size of a > record in the specified table. > Is there any built in function to know the size of each record by passing a > query? > I need this Inorder to allocate the memory after retrieving the records. > Pls suggest me. You are not giving enough information. What programming language are you using? What do you mean by a "record"? Do you want to know much memory to allocate to store each tuple resulting from a query? If so, that will obviously depend on the type of each column and the size of each field. John Barham