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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org