Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 64C104763BE for ; Thu, 2 May 2002 11:40:40 -0400 (EDT) Received: from leo.pcisys.net (leo.pcisys.net [207.76.102.240]) by postgresql.org (Postfix) with ESMTP id 293C5475FC6 for ; Thu, 2 May 2002 10:59:54 -0400 (EDT) Received: from [208.202.106.254] (moe1.meg106-254.cos.pcisys.net [208.202.106.254]) by leo.pcisys.net (8.12.1/8.12.1) via ESMTP id g42ExvMW007243; Thu, 2 May 2002 08:59:57 -0600 (MDT) env-from (hierophant@pcisys.net) User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.0.4 Date: Thu, 02 May 2002 08:59:56 -0600 Subject: Re: type of a field From: Keary Suska To: ameen eetemadi , Message-ID: In-Reply-To: <20020502094839.5372.qmail@web12601.mail.yahoo.com> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Archive-Number: 200205/8 X-Sequence-Number: 1140 on 5/2/02 3:48 AM, ameen78101@yahoo.com purportedly said: > Hello > I want to know the type of a field in a table > how can I khow it ? There are different ways. You can use pg_field_type(), or a Postgres function. It's all in the docs. RTFM. Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet"