data type
data type
От:
Ashok Chauhan <ashok@kalculate.com>
Дата:
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
Re: data type
От:
"Chris Travers" <chris@travelamericas.com>
Дата:
Hi Ashok; Check the documentation on the system catalogs. You can look up types there, etc. using joins from the system catalogs. Something like SELECT typname FROM pg_types WHERE oid IN (SELECT atttypid FROM pg_attribute WHERE attname = 'column_name' AND attrelid = (SELECT oid FROM pg_class WHERE relname = 'table_name')); Of course that is just off the top of my head, so don't count on it working. Check the developers' docs for the system catalog documentation. Best Wishes, Chris Traver ----- Original Message ----- From: "Ashok Chauhan" To: Sent: Wednesday, December 31, 2003 11:53 PM Subject: [ADMIN] data type > 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 > >