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" <jbarham@xxxxxxxxx> To: "sandhya" <sandhyar@xxxxxxxxxxxxxx> Cc: "postgre" <pgsql-admin@xxxxxxxxxxxxxx>; "Sivakumar K" <sivakumark@xxxxxxxxxxxxxx> Sent: Friday, November 11, 2005 2:40 PM Subject: Re: Reg: Records Size On 11/11/05, sandhya <sandhyar@xxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
