X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B9387D1B4D9 for ; Wed, 31 Dec 2003 11:20:00 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 66800-10 for ; Wed, 31 Dec 2003 07:19:14 -0400 (AST) Received: from delta.greatindianproducts.com (unknown [61.16.132.195]) by svr1.postgresql.org (Postfix) with ESMTP id 5E835D1B472 for ; Wed, 31 Dec 2003 07:19:07 -0400 (AST) Received: (from ashok@localhost) by delta.greatindianproducts.com (8.11.6/8.11.6) id hBVGrDU16406; Wed, 31 Dec 2003 16:53:13 GMT X-Authentication-Warning: delta.greatindianproducts.com: ashok set sender to ashok@kalculate.com using -f Subject: data type From: Ashok Chauhan To: pgsql-admin@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.3 (1.0.3-4) Date: 31 Dec 2003 16:53:13 +0000 Message-Id: <1072889593.14188.19.camel@delta.greatindianproducts.com> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/350 X-Sequence-Number: 11856 hello how i recognize the data type of any field except \d table_name; there is a function of libpq library for recognize field type but it returns a number not a name of the data type so how i know the name with the help of this number. recv_interger_number = PQftype(resultant_pointer,field_number); And this number is same in all versions of postgresql. suppose:- in version 7.2 1043 for character & 1083 for varchar so in version 7.3 is same or not. Because my requirement is the data type name in string form not in number's form. plz. help me thanks Ashok