data type

From: Ashok Chauhan <ashok(at)kalculate(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: data type
Date: 2003-12-31 16:53:13
Message-ID: 1072889593.14188.19.camel@delta.greatindianproducts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-12-31 16:56:07 Re: dump contents & missing functions
Previous Message Kenny Drobnack 2003-12-31 16:12:44 forcing postgresql 7.3 to use crypt passwords