Sophie Herold <sophie_h(at)hemio(dot)de> writes:
> I need to test a (user) given column type name, with one in the database
> for equality. To this end, I have to do some kind of normalization (e.g.
> 'timestamptz(2)' to 'timestamp (2) with time zone'.)
Perhaps format_type(oid, integer) would help you.
regards, tom lane