Bruce Momjian writes:
> > istm that pg_dump could benefit greatly if it translated internal
> > Postgres type names to the SQL92-standard names. For example, int4 ->
> > integer, int8 -> bigint, etc. This would be analogous to the
> > translation we do when parsing queries in the backend, converting
> > (e.g.) integer -> int4.
I once proposed to create a function `format_type' or some such which
would take an internal type name and a modifier and format it to some
canonical representation. I recall that was well received and I'm still
interested in that, but I'd let the function manager changes die down
first.
--
Peter Eisentraut Sernanders väg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden