Re: error codes in postgresql - Mailing list pgsql-admin

From Sivakumar K
Subject Re: error codes in postgresql
Date
Msg-id B4AF8C04F762D246A1E38EC5DFAEFC0B04EF7E@blrmail2.aus.pervasive.com
Whole thread Raw
In response to error codes in postgresql  ("sandhya" <sandhyar@amiindia.co.in>)
List pgsql-admin

 

Hi sandhya,

            I really wonder if the function name is pg_field_type (res, col_no).

The function name which returns the field type of a particular column is PQftype (res, col_no).

This returns the field type as oid.The oid of the built-in data types can be found in src/include/catalog/pg_type.h

 

When using libpq API’s you need to include only “libpq-fe.h”.

 

 

Is pg_field_type (res, col_no) an abstraction over PQftype (res, col_no) in your case?

 

Regards,

Siva Kumar.K

 

 

 

-----Original Message-----
From: sandhya [mailto:sandhyar@amiindia.co.in]
Sent:
Monday, August 22, 2005 7:12 PM
To: Sivakumar K
Cc: postgre; sandhya
Subject: Re: [ADMIN] error codes in postgresql

 

Hi,

I have one doubt,

 

Inorder to get the field type in a table i am using pg_field_type(res,col_no)

 

Col_no : Is the field no. for which i have to know the field type.

 

When i am using the above declaration, i am getting the error as,

pg_field_type undeclared(First use this function)

 

What i have to include?

I am unable to get.Pls Help me.

I have included 'libpq-fe.h".Otherthan this what i should include.

Pls help me in this regard,

 

Thanks&Regards,

Sandhya R

 

 

pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [PHP] Data insert
Next
From: "Rodrigo Sakai"
Date:
Subject: Creating tables...not a usual question (I think)