Skip site navigation (1) Skip section navigation (2)

Re: error codes in postgresql

From: "Sivakumar K" <sivakumark(at)pervasive-postgres(dot)com>
To: <sandhyar(at)amiindia(dot)co(dot)in>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: error codes in postgresql
Date: 2005-08-23 04:24:38
Message-ID: (view raw or whole thread)
Lists: pgsql-admin

Hi sandhya,

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

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?



Siva Kumar.K




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



I have one doubt,


Inorder to get the field type in a table i am using


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,



Sandhya R



pgsql-admin by date

Next:From: Rodrigo SakaiDate: 2005-08-23 07:33:02
Subject: Creating tables...not a usual question (I think)
Previous:From: Jim C. NasbyDate: 2005-08-23 00:57:52
Subject: Re: [PHP] Data insert

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group