Kate F <kate(at)cats(dot)meow(dot)at> writes:
> So, to conclude, we still have a valid use-case (which you explained a
> little more explicitly than I did). Shall I attempt to implement it?
> (that is, type_name_of() which returns TEXT)
I think I'd suggest pg_type_name ... or maybe pg_type_name_of ...
also, the code you need to convert OID to name is already there,
see regtypeout.
regards, tom lane