pg_attribute tells you the types and ordering of the attributes(columns) of a table. Then see pg_type for the size and alignmentof each type.
regards, tom lane