Re: to_typemod(type_name) information function - Mailing list pgsql-hackers

Sophie Herold <sophie_h@hemio.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