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