Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id A8BBC476691 for ; Thu, 2 May 2002 17:58:06 -0400 (EDT) Received: from mailout09.sul.t-online.com (mailout09.sul.t-online.com [194.25.134.84]) by postgresql.org (Postfix) with ESMTP id 048C6476543 for ; Thu, 2 May 2002 17:11:13 -0400 (EDT) Received: from fwd00.sul.t-online.de by mailout09.sul.t-online.com with smtp id 173Mgt-0001JM-05; Thu, 02 May 2002 21:56:35 +0200 Received: from cascal.vtb (520013531845-0001@[217.85.9.120]) by fmrl00.sul.t-online.com with esmtp id 173Mgk-1b40OWC; Thu, 2 May 2002 21:56:26 +0200 Received: from ksueber by cascal.vtb with local (Exim 3.35 #1 (Debian)) id 173MgJ-0003y2-00 for ; Thu, 02 May 2002 21:55:59 +0200 Date: Thu, 2 May 2002 21:55:59 +0200 To: pgsql-php@postgresql.org Subject: Re: type of a field Message-ID: <20020502195559.GB12934@web.de> References: <20020502094839.5372.qmail@web12601.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20020502094839.5372.qmail@web12601.mail.yahoo.com> User-Agent: Mutt/1.3.28i X-No-Archive: yes From: knut.suebert@web.de X-Sender: 520013531845-0001@t-dialin.net X-Archive-Number: 200205/18 X-Sequence-Number: 1150 ameen eetemadi schrieb: > I want to know the type of a field in a table how can I khow it ? pg_fieldtype() or something like SELECT a.attname, format_type(a.atttypid, a.atttypmod) FROM pg_class c, pg_attribute a WHERE c.relname = '$tablename' AND a.attnum > 0 AND a.attrelid = c.oid ORDER BY a.attnum; ? Bye, Knut Sübert