Thread: data type

data type

From
Ashok Chauhan
Date:
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

From
"Chris Travers"
Date:
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" <ashok@kalculate.com>
To: <pgsql-admin@postgresql.org>
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
>
>