pg_field

说明

string pg_field_type ( resource result, int field_number )

pg_field_type() 以字符串返回 PostgreSQL result 资源中指定 field_number 字段的类型。字段编号从 0 开始。

参考 pg_field_name() 页面中的例子。

注: 本函数以前的名字为 pg_fieldtype()。

参见 pg_field_prtlen() 和 pg_field_name()。

add a note User Contributed Notes

marxarelli
03-Jan-2006 06:34


Because complete documentation is always helpful, here are all the PostgreSQL general purpose types as they are listed in the 8.1 documentation, and each corresponding string returned by pg_field_type().



bigint => int8

bigserial => int8

bit => bit

bit varying => varbit

boolean => bool

box => box

bytea => bytea

character varying => varchar

character => bpchar

cidr => cidr

circle => circle

date => date

double precision => float8

inet => inet

integer => int4

interval => interval

line => line

lseg => lseg

macaddr => macaddr

money => money

numeric => numeric

path => path

point => point

polygon => polygon

real => float4

smallint => int2

serial => int4

text => text

time => time

time with time zone => timetz

timestamp => timestamp

timestamp with time zone => timestamptz



And for the record... (note the 7.4 client lib)

# postmaster --version

postmaster (PostgreSQL) 8.0.4



# ldd libphp4.so

...

libpq.so.3 => /usr/lib/libpq.so.3 (0xb7ac8000)

...

andy at a 2 h d dot com
04-May-2003 03:09


The types returned are:

  bool

  int2 (smallint)

  int4

  int8 (bigint)

  numeric

  float4 (real / float)

  float8 (double)

  timestamp

  date

  time

  varchar

  bpchar (fixed leng string, 'blank padded char')

  inet (ip address)

  money



There are some other more esoteric types, e.g. 'circle', but these are the most common.

add a note