Re: Data types mapping - Mailing list pgsql-novice

Doug Silver <dsilver@urchin.com> writes:
> I have a partial mapping of some of the fields with their internal type, e.g.:
> integer    4
> smallint    5

Some of these are wrong ... from memory, int4 is 23.

> What internal table has the complete mapping?

SELECT oid, typname FROM pg_type

This will give you a lot of things you did not realize were types, too.
You might prefer to ignore rows with typtype != 'b'.

            regards, tom lane