Re: [HACKERS] Types

Michael Meskes wrote:
>libpq gives back the internal typenumbers of the attributes. How do I know
>which number means which type? I need to find out if the type is an array.

If the type is 1007, then:

template1=> select typname from pg_type where oid = 1007;
typname
-------
_int4
(1 row)

If the typename begins with an underscore, it is an array type.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"He that giveth unto the poor shall not lack..."
Proverbs 28:27