On 18/11/17 16:50, Tom Lane wrote: > Sophie Herold <sophi...@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 >
I am not sure how. I am exactly looking for the the second argument integer. The only workaround I can think of is to create a table with a column with that type, ask the pg_catalog for the typemod afterwards and rollback the creation. But that doesn't sound like a proper solution to me. Best, Sophie